Find Constraints on a table

select b.COLUMN_NAME
from INFORMATION_SCHEMA.table_constraints a
inner join INFORMATION_SCHEMA.key_column_usage b on
a.CONSTRAINT_CATALOG = b.CONSTRAINT_CATALOG and
a.CONSTRAINT_SCHEMA = b.CONSTRAINT_SCHEMA and
a.CONSTRAINT_NAME = b.CONSTRAINT_NAME
wherea.TABLE_CATALOG = '<db Name>'
anda.TABLE_SCHEMA = '<owner Name'
anda.TABLE_NAME = '<table Name>'
anda.CONSTRAINT_TYPE = '<constraint Type>'
order by b.ordinal_position