Viewing post 1 (of 1 total)
See BOL:
CREATE INDEX, DROP_EXISTING
"Because nonclustered indexes contain the clustering keys, the nonclustered indexes must be rebuilt when a clustered index is dropped. If a clustered index is recreated, the nonclustered...
October 15, 2008 at 6:47 pm
#885593