Wednesday, March 7, 2012

drop all the indexes on a table

is there a way to drop all the indexes on a table other than listing them out separately in a drop index statement?YOu can drop the table, which will implicitly drop all of the indexes.

Sorry - I couldn't resist. ;)|||do a select into

drop old table

rename new table

No comments:

Post a Comment