/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 vote125 views1 answer
Jooq convert using gbk
SQL
0 vote132 views1 answer
Timestamp(0) postgresql
SQL
0 vote143 views1 answer
Create relationship with betwen two tables in postgersql
SQL
5 votes153 views2 answers
Postgresql insert select
SQL
1 vote132 views2 answers
Mysql current user
SQL
0 vote153 views3 answers
Mysqli count down
SQL
1 vote147 views1 answer
Mysql pretty date format
SQL
0 vote148 views1 answer
Trigger stock phpmyadmin output message
SQL
19 votes147 views3 answers
How to change column type psql
SQL
0 vote169 views1 answer
SQL Cut part string
SQL