/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 vote343 views1 answer
Object of class sendgrid\mail\mail could not be converted to string
SQL
0 vote342 views1 answer
Java mysql swing example
SQL
0 vote352 views1 answer
The fetch keyword oracle
SQL
1 vote340 views1 answer
How to show index type in postgresql
SQL
10 votes308 views2 answers
Mysql select timestamp group by day
SQL
1 vote341 views1 answer
Quit mysql
SQL
0 vote340 views1 answer
Mysql subtract month from timestamp
SQL
4 votes291 views1 answer
Sql list users and roles
SQL
4 votes376 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
18 votes350 views3 answers
Get the list of all tables in sql server
SQL