/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

0 vote292 views1 answer
Bash block size ls /var/lib/mysql
SQL
0 vote293 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote290 views1 answer
Changer un mot de passe mysql
SQL
9 votes289 views2 answers
Oracle all tables in schema
SQL
2 votes294 views2 answers
Install sqlalchemy
SQL
0 vote294 views1 answer
Mysql docker image for macbook m1
SQL
0 vote308 views1 answer
Alter fedora mysql 8.0 user
SQL
0 vote297 views1 answer
Power query case when
SQL
-1 vote292 views2 answers
An error occurred while installing mysql2 (0.3.20), and Bundler cannot continue.
SQL
4 votes297 views1 answer
Oracle user tables
SQL