/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

3 votes237 views1 answer
Mysql UPDate with enner join
SQL
0 vote307 views1 answer
Hierarchal database table
SQL
1 vote248 views1 answer
Type int in mysql maxlenght
SQL
0 vote202 views1 answer
Ms sql print more than 1 variable
SQL
0 vote241 views1 answer
Python mysql query where
SQL
3 votes262 views1 answer
Sql multi column index performance
SQL
1 vote224 views2 answers
Procedure pl/sql
SQL
2 votes302 views1 answer
Postgresql group by month and year
SQL
7 votes257 views1 answer
Set sequence value oracle
SQL
0 vote258 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL