/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

4 votes201 views3 answers
Check if two date ranges overlap sql server
SQL
0 vote206 views1 answer
Alter boolean column postgresql
SQL
8 votes217 views3 answers
SQL column name
SQL
2 votes196 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote202 views1 answer
Get enginge db mysql
SQL
0 vote231 views1 answer
Insert into table with only identity column
SQL
0 vote217 views1 answer
Sql server convert to guid
SQL
0 vote207 views2 answers
Sql query for getting details by id
SQL
1 vote222 views1 answer
Name of today sql
SQL
0 vote215 views1 answer
Restart sql server command line linux
SQL