/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 vote181 views1 answer
Show all mongodb
SQL
0 vote168 views1 answer
Delete ids between sql
SQL
0 vote159 views1 answer
Sql min
SQL
8 votes152 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote179 views1 answer
What does the -p flag do in mysql cli
SQL
1 vote147 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote165 views2 answers
Amazon linux postgresql client
SQL
0 vote218 views1 answer
Order by number of character in sql
SQL
0 vote191 views1 answer
From _sqlite3 import * ImportError: DLL load failed: Das angegebene Modul wurde nicht gefunden.
SQL
7 votes150 views4 answers
How to reset the identity column in sql server
SQL