Primary key constraint:
Code:
select T1.CONSTRAINT_NAME, T2.COLUMN_NAME
from INFORMATION_SCHEMA.TABLE_CONSTRAINTS T1
left join INFORMATION_SCHEMA.KEY_COLUMN_USAGE as T2 on T1.CONSTRAINT_NAME = T2.CONSTRAINT_NAME
where T1.TABLE_NAME = '<table name>'
and T1.CONSTRAINT_TYPE = 'PRIMARY KEY'
Foreign key constraints:
Code:
select T2.CONSTRAINT_NAME, T1.COLUMN_NAME, T4.TABLE_NAME as REF_TABLE_NAME, T4.COLUMN_NAME as REF_COLUMN_NAME
from INFORMATION_SCHEMA.KEY_COLUMN_USAGE as T1
left join INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS as T2 on T2.CONSTRAINT_NAME = T1.CONSTRAINT_NAME
left join INFORMATION_SCHEMA.TABLE_CONSTRAINTS as T3 on T2.UNIQUE_CONSTRAINT_NAME = T3.CONSTRAINT_NAME
left join INFORMATION_SCHEMA.KEY_COLUMN_USAGE as T4 on T3.CONSTRAINT_NAME = T4.CONSTRAINT_NAME
where T1.TABLE_NAME = '<table name>'
and T1.ORDINAL_POSITION = T4.ORDINAL_POSITION