/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 vote132 views2 answers
How to install mssql on mac
SQL
0 vote127 views1 answer
Count columns psql(PostreSQL)
SQL
-1 vote124 views3 answers
Compute age mysql
SQL
8 votes117 views4 answers
Postgresql server restart
SQL
2 votes113 views2 answers
Postgres set user as superuser
SQL
2 votes124 views1 answer
Pdo mysql insert
SQL
1 vote133 views1 answer
Create new index takes long time postgresql
SQL
2 votes118 views1 answer
Add default sql server
SQL
57 votes201 views5 answers
How to create a new user in postgresql
SQL
0 vote116 views1 answer
See Foreign Key
SQL