SQL 索引相關

取 PK
Select * from Sysobjects Where Parent_obj=OBJECT_ID('TableName') and Xtype='PK'
刪除
Alter Table TableName Drop PK_Name(上述求得的 Name 值)

SP_Helpindex TableName 求得索引
Drop Index TableName.IndexName