SELECT
[Name]
FROM [sys].[key_constraints]
WHERE
[type] = 'PK'
AND
OBJECT_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 NULL
ALTER TABLE [dbo].[PropertyChannel]
ADD
CONSTRAINT PK_PropertyChannel_ID PRIMARY KEY (PropertyChannelId)
SQL Get the primary key name/ drop pk/ add pk
最新推荐文章于 2022-10-16 10:18:25 发布