/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

5 votes277 views2 answers
Oracle rename table
SQL
0 vote299 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
8 votes270 views5 answers
Alter table add column with default value
SQL
1 vote273 views1 answer
Sql convert month name to number
SQL
1 vote278 views1 answer
Mysql month name extract
SQL
0 vote274 views1 answer
Can sqldatareader be null
SQL
0 vote245 views1 answer
Big query add table rows to another table
SQL
6 votes259 views1 answer
Oracle trigger after connect
SQL
2 votes277 views1 answer
Change primary key sql
SQL
1 vote265 views1 answer
Sql get missing id
SQL