In this article, you will learn how to check or find the column name which is the primary key column of a specific table in SQL Server. There are various ways to find the primary key column in SQL server.
Here are some examples to check or find the
Primary Key column name in SQL Server
SELECT Col.Column_Name as 'PRIMARY KEY COLUMN' FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS Tab, INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE Col WHERE Col.Constraint_Name = Tab.Constraint_Name AND Col.Table_Name = Tab.Table_Name AND Constraint_Type = 'PRIMARY KEY' AND Col.Table_Name = '';
SELECT KU.table_name as TABLENAME ,column_name as 'PRIMARY KEY COLUMN' FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS KU ON TC.CONSTRAINT_TYPE = 'PRIMARY KEY' AND TC.CONSTRAINT_NAME = KU.CONSTRAINT_NAME AND KU.table_name='' ORDER BY KU.TABLE_NAME, KU.ORDINAL_POSITION;
SELECT COLUMN_NAME as 'PRIMARY KEY COLUMN' FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE TABLE_NAME = '';
I hope this article will help you to understand how to check or find the column name which is the primary key column of a specific table in SQL Server.
Share your valuable feedback, please post your comment at the bottom of this article. Thank you!