/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

2 votes116 views1 answer
How to get weekday from old date in sql
SQL
0 vote250 views1 answer
Get first match in each group mysql query
SQL
6 votes118 views1 answer
Oracle rank
SQL
0 vote87 views1 answer
Jooq finding lastest value in table
SQL
0 vote106 views1 answer
Sql create text column limited values
SQL
1 vote110 views1 answer
Psql human readable
SQL
8 votes97 views1 answer
Ltrim sql
SQL
1 vote115 views1 answer
Change table to innodb mysql
SQL
1 vote110 views1 answer
SQLite order random
SQL
0 vote121 views1 answer
Mysql get nth highest
SQL