/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 vote278 views1 answer
Sqlite get date only
SQL
0 vote254 views1 answer
Oracle right characters
SQL
6 votes284 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote276 views1 answer
Get last date join sql
SQL
0 vote298 views1 answer
Mysql record group by created date count
SQL
3 votes287 views1 answer
Locate sql server
SQL
0 vote303 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
7 votes348 views2 answers
3rd height salary sql
SQL
0 vote297 views3 answers
Condition in count sql
SQL
0 vote255 views1 answer
Sql right characters
SQL