/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 vote205 views1 answer
Oracle table privileges
SQL
5 votes187 views5 answers
Sqlite install python
SQL
3 votes182 views1 answer
Select without null values sql
SQL
2 votes192 views1 answer
Q operator in sql
SQL
0 vote194 views1 answer
Get the previous column of a table in mysql
SQL
2 votes194 views1 answer
Mysql sysdate - 1 day
SQL
5 votes188 views1 answer
Sql add column after another
SQL
1 vote218 views1 answer
Add sequence postgres
SQL
7 votes195 views2 answers
Get database size mysql
SQL
0 vote188 views1 answer
18446744073709551615 mariadb left join order by
SQL