/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 vote138 views1 answer
Postgres can integer fields be negative
SQL
0 vote201 views1 answer
How to add auto increment primary key
SQL
20 votes148 views6 answers
Mysql reset auto increment
SQL
1 vote140 views1 answer
Oracle sql create or replace view
SQL
3 votes145 views1 answer
Insert into table from another table mysql
SQL
-1 vote131 views2 answers
Get day in sql
SQL
1 vote133 views1 answer
Where date = max(date) in sql
SQL
-1 vote128 views1 answer
How to switch user in mysql
SQL
1 vote137 views1 answer
Md5 encryption for existing records
SQL
0 vote124 views1 answer
Get who is hired in january in sql
SQL