/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 vote233 views1 answer
Grouping by email domain mysql
SQL
0 vote185 views1 answer
Update sql join multiple tables
SQL
0 vote266 views1 answer
Mysql case when on date
SQL
0 vote230 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
-1 vote230 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote259 views1 answer
Ansi sql count duplicate rows
SQL
2 votes230 views1 answer
Plsql block
SQL
0 vote210 views1 answer
Provera dupliranih konatakata
SQL
0 vote274 views1 answer
Alternative for LIMIT sql
SQL
0 vote263 views1 answer
Insert into table with only identity column
SQL