/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

3 votes167 views1 answer
Mysql set field unique
SQL
0 vote203 views1 answer
Mysql faster delete
SQL
1 vote189 views1 answer
Date in where on datetime column clause mysql
SQL
0 vote188 views1 answer
Psotgres multiple values
SQL
1 vote181 views1 answer
Moodle query first user access
SQL
2 votes182 views3 answers
Copy data from one table column to another table column in sql
SQL
0 vote183 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote178 views1 answer
Mysql dump everythign
SQL
7 votes152 views1 answer
Mysql load data infile csv
SQL
0 vote226 views1 answer
Mysl like insert a variable
SQL