October 20, 2011 at 12:28 am
hey i want to know when ever we drop a table then its indexes automatically droped or not ?
October 20, 2011 at 1:14 am
The assciated indexes would be dropped.
thanks
sarat 🙂
Curious about SQL
October 20, 2011 at 1:37 am
Yes, all the indexes (clustered and nonclustred) dropped automatically whenever a table is dropped.
October 20, 2011 at 1:38 am
As are triggers.
CEWII
October 20, 2011 at 4:13 am
all the object associated with that will be dropped, like if you dropping a table the associated constraints, indexes, triggers,columns everything will dropped as it is higher body from those.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply