/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

25 votes162 views5 answers
Uninstall mysql ubuntu
SQL
1 vote170 views1 answer
Get current date in pyspark sql
SQL
0 vote144 views1 answer
Mariadb current date plus 1 day
SQL
2 votes150 views1 answer
No data found oracle
SQL
0 vote151 views1 answer
Sql comand for removing data from table
SQL
1 vote139 views1 answer
Sql not equal multiple columns
SQL
1 vote147 views3 answers
Mysql connection string
SQL
1 vote157 views1 answer
Postgresql can you have null foreign key
SQL
0 vote171 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote163 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL