Script to drop all indexes on a table

Question

Script to drop all indexes on a table

gprasad

SSC Enthusiast

Points: 186
More actions
October 13, 2007 at 6:36 pm

#179069

Comments posted to this topic are about the item Script to drop all indexes on a table

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Langston Montgomery SSC Eights! Points: 934 More actions · Answer 1

Good script... appreciate the work.

One thing though, is that this script attempts to drop indexes for primary keys, which is not allowed explicitly. One has to drop the actual constraint.