/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 vote131 views1 answer
Value of sold product using having and group by in sql
SQL
0 vote133 views1 answer
Start stop mysql linux
SQL
0 vote136 views1 answer
Sql delete dastabase
SQL
6 votes120 views2 answers
Mysql concatenate two columns into one
SQL
0 vote120 views2 answers
Sqlite unix timestamp
SQL
0 vote114 views1 answer
Selecting Data in SQL - Select Data
SQL
0 vote120 views1 answer
Mysql does collate nopad recognize space
SQL
5 votes136 views4 answers
Change auto increment mysql
SQL
1 vote151 views1 answer
How to get alternate records from a table in sql
SQL
2 votes126 views2 answers
Run mysql command from bash
SQL