/SQL/Check if a column is a primary key in sql server

Check if a column is a primary key in sql server

SELECT  K.TABLE_NAME ,
    K.COLUMN_NAME ,
    K.CONSTRAINT_NAME
FROM    INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS C
        JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE AS K ON C.TABLE_NAME = K.TABLE_NAME
                                                         AND C.CONSTRAINT_CATALOG = K.CONSTRAINT_CATALOG
                                                         AND C.CONSTRAINT_SCHEMA = K.CONSTRAINT_SCHEMA
                                                         AND C.CONSTRAINT_NAME = K.CONSTRAINT_NAME
WHERE   C.CONSTRAINT_TYPE = 'PRIMARY KEY'
        AND K.COLUMN_NAME = 'keycol';

Source: stackoverflow.com

Similar codes

0 vote133 views1 answer
SQL Server format datetime
SQL
0 vote150 views1 answer
Grant owner postgresql
SQL
0 vote154 views1 answer
How we can perform acid Operations in sql with examples
SQL
0 vote175 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
3 votes162 views1 answer
Oracle function return
SQL
0 vote105 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
5 votes137 views2 answers
Mysqldump password
SQL
0 vote140 views1 answer
Oracle job class
SQL
22 votes191 views4 answers
Mysql format date
SQL
0 vote147 views1 answer
Mod function example
SQL