clustered and notClustered index

hi,
i am right:
if i create SP dropping clustered index and recreating them will SQL
automatically recreate nonClustered index for that table?
i use create ...with drop_existing only 4 clustered index
when nonClustered indexes are recreated? just after the clustered was
created (in this case should i put some delay before starting the second
one) o after SP ends?You should recreate the index instead of dropping it an creating it because
when you delete the clustered index all non clustered indexes are deleted an
d
created
And when you create the clustered index again all non clustered indexes are
deleted and created
lookup rebuilding an index in BOL
http://sqlservercode.blogspot.com/
"benamis" wrote:

> hi,
> i am right:
> if i create SP dropping clustered index and recreating them will SQL
> automatically recreate nonClustered index for that table?
> i use create ...with drop_existing only 4 clustered index
>
> when nonClustered indexes are recreated? just after the clustered was
> created (in this case should i put some delay before starting the second
> one) o after SP ends?
>