/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 votes309 views3 answers
Access denied for user 'root'@'localhost' mariadb
SQL
0 vote349 views1 answer
Run mssql server terminal
SQL
1 vote456 views1 answer
Aqua Data studio postgresql ssl
SQL
1 vote370 views1 answer
Oracle get current schema
SQL
0 vote304 views8 answers
Convert sql query to linq online
SQL
7 votes369 views3 answers
Convert ansi sql
SQL
0 vote348 views1 answer
Alter table name including schema
SQL
9 votes364 views2 answers
Sql server check table exists
SQL
0 vote369 views2 answers
How to count codition
SQL
0 vote355 views1 answer
Shell script to log mysql cpu usage
SQL