/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 vote207 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
1 vote166 views1 answer
Table infromation in sql server
SQL
0 vote178 views1 answer
Downgrading sql localdb visual studio
SQL
0 vote272 views1 answer
Python mysql check if database exists
SQL
0 vote247 views1 answer
Oracle current date minus 1 day
SQL
20 votes179 views2 answers
Counting in sql
SQL
-1 vote270 views1 answer
Minus vs except in sql
SQL
0 vote201 views1 answer
Declaring variables in pl sql
SQL
0 vote202 views1 answer
Python sqlalchemy connection show server
SQL
0 vote194 views1 answer
Drop unique
SQL