Menu Close

Category: New

How can I find primary key name?

How can I find primary key name? Get Primary Key Column Name Programmatically select C.COLUMN_NAME FROM. INFORMATION_SCHEMA.TABLE_CONSTRAINTS T. JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE C. ON C.CONSTRAINT_NAME=T.CONSTRAINT_NAME. WHERE. C.TABLE_NAME=’Employee’…