/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 vote294 views1 answer
Sql server size of every table in a db
SQL
2 votes328 views3 answers
Postgres json to string
SQL
2 votes352 views1 answer
Find column in all stored procedures sql server
SQL
0 vote298 views1 answer
Sql DATE = GETDATE()
SQL
0 vote309 views1 answer
Sql query contains multiple ids
SQL
0 vote290 views1 answer
Retornar apenas o ano mysql date
SQL
3 votes284 views2 answers
WhereIn SQL
SQL
-1 vote314 views2 answers
Postgres autoincrement primary key
SQL
0 vote291 views2 answers
Postgresql display subquery as json
SQL
0 vote334 views1 answer
Java sql timestamp now
SQL