/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 vote127 views1 answer
Greater than or equal to symbol in postgres
SQL
0 vote129 views1 answer
Oracle drop default value
SQL
0 vote134 views1 answer
Create or replace view postgress
SQL
10 votes243 views4 answers
Mysql if else
SQL
0 vote124 views1 answer
C# add a textbox in mysql select
SQL
0 vote161 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL
1 vote149 views2 answers
Mysql insert generate serie
SQL
0 vote151 views1 answer
Add a new column into table
SQL
0 vote130 views1 answer
Longtext sql
SQL
46 votes200 views4 answers
Create column sql
SQL