/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

8 votes207 views2 answers
Grant all privileges database postgres to user
SQL
0 vote219 views1 answer
Add new column in sql with foreign key
SQL
1 vote221 views3 answers
How to create a table structure from another table in mysql
SQL
7 votes204 views4 answers
Lowest salary in sql
SQL
0 vote182 views1 answer
Oracle drop default value
SQL
1 vote200 views1 answer
Mysql backup skip table
SQL
0 vote193 views1 answer
Power bi find all ids not in other tables
SQL
0 vote211 views1 answer
Psql show db
SQL
0 vote197 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Tabl
SQL
1 vote199 views1 answer
Postgresql reset serial counter after deleting content
SQL