/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

7 votes177 views3 answers
Sql server reset auto increment
SQL
0 vote328 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL
0 vote127 views1 answer
Postgresql subquery
SQL
6 votes172 views2 answers
Mysql first day of month
SQL
0 vote178 views1 answer
Import Data in MySQL without using any other software
SQL
1 vote160 views1 answer
T-sql find object by name
SQL
1 vote181 views1 answer
Sql random sampling per group
SQL
2 votes223 views1 answer
Create mysql user on all hosts
SQL
1 vote175 views1 answer
Mysql get latest duplicate rows
SQL
3 votes200 views1 answer
Set default today mysql
SQL