/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 vote323 views1 answer
How to get first 10 records of a table in mysql
SQL
12 votes323 views1 answer
Script to add new column in table sql
SQL
0 vote310 views1 answer
Sql cross apply vs join
SQL
0 vote339 views1 answer
Vs 2019 connect to local mysql database
SQL
0 vote306 views1 answer
Grant access on table in oracle
SQL
8 votes310 views1 answer
Alter tablespace add datafile
SQL
0 vote306 views1 answer
Oracle execute immediate quotes
SQL
1 vote340 views3 answers
What is union in sql
SQL
4 votes370 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
2 votes385 views1 answer
Install postgresql centos 5
SQL