/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

16 votes134 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote131 views1 answer
Sqlite select split string
SQL
5 votes127 views1 answer
Minecraft java port number
SQL
1 vote137 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote127 views1 answer
Mysql export and import
SQL
0 vote148 views1 answer
Remove transient options sql wordpress
SQL
1 vote128 views1 answer
Get rows affected mysql python
SQL
5 votes130 views1 answer
Oracle find foreign key dependencies
SQL
8 votes131 views1 answer
Sql limit results returned
SQL
0 vote135 views1 answer
Python mysqlclient library not found for -lssl
SQL