/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

31 votes254 views4 answers
Mysql grant execute
SQL
17 votes178 views6 answers
Current date in sql
SQL
1 vote171 views3 answers
How to filter repeated same result using sql query
SQL
0 vote171 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL
0 vote252 views1 answer
Migrations.RunSQL
SQL
4 votes260 views2 answers
Convert utc to est sql
SQL
0 vote410 views1 answer
Power bi connect to postgresql
SQL
3 votes178 views1 answer
Sql server version query
SQL
0 vote217 views1 answer
Get create sql of hibernqte entity
SQL
0 vote176 views1 answer
Data structures in sql
SQL