/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 vote249 views1 answer
Get max salary from each department sql
SQL
3 votes162 views1 answer
System.debug apex
SQL
1 vote226 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote216 views2 answers
Sql stored procedure for access frontend
SQL
0 vote228 views1 answer
Query for backup a database at another location in file system
SQL
0 vote167 views1 answer
Java spring boot connect to sql server
SQL
0 vote252 views1 answer
Sql describe
SQL
2 votes249 views2 answers
How to add not null constraint in sql
SQL
0 vote215 views1 answer
Mysql root localhost run
SQL
6 votes231 views2 answers
Clear a table in mysql
SQL