【一句话学习笔记SQL篇】删除表的主键

还是那句老话，直接上‘酸菜’。

 

--DropPK

DECLARE @Constraint_Name varchar (200)

 

SELECT @Constraint_Name=Name

FROM dbo.sysobjects

WHERE Xtype='PK'

      and Parent_Obj =(select[ID]

                               fromdbo.sysobjects

                                whereid= object_id(N'[table_name]')

       and OBJECTPROPERTY(id,N'IsUserTable')= 1)

 

IF @Constraint_NameISnot NULL

BEGIN

  EXEC ('alter tabletable_name drop constraint '+@Constraint_Name)

END