/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

1 vote370 views1 answer
How to subtract from the value of a table in sql
SQL
1 vote365 views2 answers
Mysql filter by date mount
SQL
0 vote347 views2 answers
What is 1=2 in sql
SQL
3 votes381 views1 answer
Locate sql server
SQL
0 vote349 views1 answer
Sql counter column
SQL
0 vote353 views1 answer
Set mysql socket file docker windows
SQL
2 votes381 views1 answer
Sqlplus clear screen
SQL
0 vote438 views1 answer
Why do we need data structure in sql
SQL
0 vote434 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
3 votes363 views1 answer
Sql server version query
SQL