/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

3 votes209 views1 answer
Sql server check version
SQL
4 votes212 views1 answer
Mysql set max connections
SQL
0 vote221 views2 answers
How to get last inserted id in sql server c#
SQL
2 votes198 views1 answer
Drop table if exists in postgres
SQL
0 vote191 views1 answer
Create dabase postgresql
SQL
0 vote180 views1 answer
Flask_sqlalchemy install
SQL
1 vote293 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote200 views1 answer
Html css mobile menu arrow dropdown
SQL
31 votes218 views4 answers
Mysql grant execute
SQL
0 vote242 views2 answers
List all constraints in postgres
SQL