Get a Primary Key Column Name in Entire Database

Joginder Banger
Dec 01 2014
Code

1.1k
0
0

Hi Everybody, Everyone knows Primary key main concept in our SQL Database. If we have no primary Key concept painful task to Handle Database.

In this query return of Current database name, Primary Column Name and last is Table Name.

Select constraint_catalog [Database Name], column_name [Primary column],TABLE_NAME [Table Name] FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE OBJECTPROPERTY(OBJECT_ID(constraint_name), 'IsPrimaryKey') = 1 AND table_name in( select name from sys.tables)

In the last month asked this type of question in Interview. How to Get all Primary key column Name in single Database. So i share this question with Respective C-sharpcorner.com Readers.