CrazyMan (1/16/2009)
Alter tableAlter table Table Name Drop Constraint ConstraintName
True, if the clustered index is part of a primary key or unique constraint. If it's just a plain index, DROP INDEX is the command to use.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability