/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 vote158 views1 answer
Create or replace view postgress
SQL
23 votes150 views6 answers
Delete all rows from table sql
SQL
8 votes158 views2 answers
Mysql grant all privileges to user from any host
SQL
3 votes166 views2 answers
Tsql join multiple record in one string
SQL
0 vote150 views1 answer
Mysql grant all on all databases
SQL
0 vote164 views1 answer
Can sqldatareader be null
SQL
12 votes136 views5 answers
Sql merge
SQL
0 vote157 views1 answer
Search column name sql
SQL
0 vote155 views1 answer
Tsql cmd exec script from file
SQL
0 vote163 views1 answer
Mysql order by rand limit 1 really slow
SQL