/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

6 votes192 views2 answers
Difference between join vs union
SQL
0 vote181 views1 answer
Delete record by id sql
SQL
0 vote171 views1 answer
Sql server check whether column has same equal values
SQL
3 votes174 views2 answers
Sql select data from last week
SQL
0 vote173 views1 answer
How to insert a uniqueidentifier in sql
SQL
1 vote236 views2 answers
Mysql SELECT
SQL
1 vote199 views1 answer
Oracle list data files
SQL
0 vote169 views1 answer
Postgresql create table many-to-many
SQL
2 votes166 views1 answer
Sql to char function with date
SQL
7 votes189 views1 answer
Return insert results in POSTGRESQL
SQL