/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 votes312 views4 answers
Index in mysql
SQL
0 vote308 views1 answer
How to get one year old query from plan cache
SQL
0 vote304 views1 answer
Running mysql from bash sc
SQL
14 votes304 views1 answer
Oracle alter table add column not null
SQL
1 vote270 views2 answers
Reset mysqli fetch_arra
SQL
0 vote282 views1 answer
Get record which is available in one table but not in another mysql
SQL
0 vote265 views1 answer
Insert to first table if field A equals field B from a second table using sql
SQL
0 vote299 views2 answers
Sql query inner join 3 tables
SQL
4 votes288 views1 answer
Mysql not equal
SQL
0 vote335 views1 answer
Why do we need data structure in sql
SQL