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 )
Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular