/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 vote220 views1 answer
Sql sort ages
SQL
1 vote196 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
6 votes208 views4 answers
Remove spaces sql server
SQL
0 vote199 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote185 views1 answer
ALL_TAB_PARTITIONS
SQL
0 vote201 views1 answer
Sql select inside select sub query
SQL
0 vote153 views1 answer
Java spring jdbc connect to postgresql
SQL
1 vote220 views1 answer
Select inside insert query
SQL
0 vote199 views1 answer
Normalization in database
SQL
20 votes186 views2 answers
Counting in sql
SQL