/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 votes345 views2 answers
Find string in stored procedure sql server
SQL
3 votes336 views4 answers
Show databases in sql server
SQL
4 votes330 views2 answers
Sql table
SQL
1 vote336 views1 answer
Postgres select as csv
SQL
5 votes316 views3 answers
Truncate function in sql oracle
SQL
0 vote408 views1 answer
Hierarchal database table
SQL
0 vote350 views1 answer
(PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at
SQL
0 vote305 views1 answer
Sql select maximum column with other columns returned
SQL
0 vote326 views1 answer
Download mysql database to excel in android studio
SQL
1 vote365 views1 answer
Sql select whole row max column
SQL