SQL Get the primary key name/ drop pk/ add pk

来源:互联网 发布:amd是什么软件 编辑:程序博客网 时间:2024/06/03 03:06
SELECT [Name]FROM [sys].[key_constraints]WHERE[type] = 'PK'ANDOBJECT_NAME(parent_object_id) = N'PropertyChannel' ALTER TABLE [dbo].[PropertyChannel]DROP     CONSTRAINT [PK_PropertyChannel_ID] ALTER TABLE [dbo].[PropertyChannel]ADD     PropertyChannelId int identity(1, 1) NOT NULLALTER TABLE [dbo].[PropertyChannel]ADD    CONSTRAINT PK_PropertyChannel_ID PRIMARY KEY (PropertyChannelId)

0 0
原创粉丝点击