/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

2 votes324 views1 answer
Query any digits record
SQL
-2 votes312 views1 answer
Remove root password mysql
SQL
8 votes318 views3 answers
Oracle auto_increment
SQL
3 votes323 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote305 views1 answer
Create temporal table in sql
SQL
2 votes317 views1 answer
Mysql query unique column
SQL
-1 vote342 views1 answer
Minus vs except in sql
SQL
2 votes311 views1 answer
Oracle sql concatenate results into string
SQL
25 votes318 views6 answers
Change column name mysql
SQL
18 votes267 views2 answers
How to get all the tables displayed in oracle
SQL