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