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 )
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: