/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

10 votes265 views6 answers
Mysql set root password
SQL
0 vote238 views2 answers
How to Alter column in SQL Server - NAYCode.com
SQL
0 vote281 views1 answer
Osm2pgsql mac
SQL
0 vote221 views1 answer
Update table sql multiple set
SQL
0 vote228 views1 answer
Turnicate in mysql
SQL
0 vote212 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote229 views1 answer
Sql server create constraint
SQL
6 votes233 views2 answers
Difference between join vs union
SQL
0 vote235 views1 answer
Sql pad left 0
SQL
8 votes253 views2 answers
Replace string value in sql
SQL