/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

1 vote282 views2 answers
Get table column names sql laravel
SQL
4 votes244 views1 answer
SQL order random
SQL
0 vote264 views1 answer
Empty table sqlite
SQL
0 vote355 views1 answer
Compare strings lexicographically in sql
SQL
17 votes266 views6 answers
Get last record in sql
SQL
0 vote270 views1 answer
How to move a column to different spot mysql
SQL
1 vote266 views4 answers
Sql now
SQL
0 vote274 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote264 views1 answer
SQL Server Enterprise
SQL
1 vote293 views1 answer
Sql how to replace full stop
SQL