devxlogo

Check if a Primary Key Exists on a Table

Check if a Primary Key Exists on a Table

You can use IF NOT EXISTS?to check whether a Primary Key is missing and add it as follows:

IF NOT EXISTS (SELECT * FROM sys.tables tINNER JOIN sys.schemas s ON t.schema_id = s.schema_idINNER JOIN sys.indexes i on i.object_id = t.object_idWHERE i.is_primary_key = 1AND s.name = 'dbo' AND t.name = 'TableName')ALTER TABLE dbo.TableNameADD CONSTRAINT PK_TableName PRIMARY KEY (Column1) WITH ( ONLINE = ON )

devx-admin

Share the Post: