/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 vote123 views1 answer
Mysql last friday of current month
SQL
0 vote98 views1 answer
How to connect pgadmin with excel
SQL
13 votes113 views1 answer
Sql join 3 tables on id
SQL
1 vote109 views1 answer
Print all records of table in mysql
SQL
4 votes108 views1 answer
SQL find text in SP
SQL
41 votes167 views6 answers
Alter table add column in SQL Server
SQL
0 vote140 views1 answer
Postgresql alter table sequence
SQL
-1 vote109 views1 answer
Count occurrences sql
SQL
2 votes115 views2 answers
Sqlalchemy return id after insert
SQL
1 vote98 views1 answer
Launch sql script from docker in mysql
SQL