/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 vote339 views2 answers
Populate sql table with random data
SQL
0 vote377 views1 answer
Oracle sql all days except weekends
SQL
0 vote378 views3 answers
Condition in count sql
SQL
0 vote314 views1 answer
Print sum of values sql
SQL
0 vote345 views1 answer
Mysql filter based on datediff
SQL
0 vote327 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote338 views1 answer
Sql string length postgresql
SQL
0 vote346 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote341 views1 answer
Funzioni plsql
SQL
2 votes335 views1 answer
Oracle sql drop table purge
SQL