/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

1 vote135 views3 answers
Connection string mysql
SQL
4 votes116 views1 answer
To date oracle with time
SQL
0 vote112 views1 answer
Print orcale
SQL
0 vote116 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote108 views1 answer
Edit a field mysql terminal
SQL
0 vote151 views1 answer
Generate sql from specific migration ef core
SQL
16 votes117 views2 answers
Mysql date between two dates
SQL
4 votes109 views1 answer
Oracle session date format
SQL
4 votes117 views1 answer
Restart for pg_hba.conf file
SQL
1 vote129 views1 answer
Oracle stop
SQL