Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script to drop all indexes on a table Expand / Collapse
Author
Message
Posted Saturday, October 13, 2007 6:36 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 19, 2004 8:49 AM
Points: 4, Visits: 1
Comments posted to this topic are about the item Script to drop all indexes on a table


Post #410466
Posted Thursday, June 17, 2010 11:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, April 11, 2014 6:30 PM
Points: 37, Visits: 435
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.
Post #939106
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse