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
where	a.TABLE_CATALOG = '<db Name>'
and	a.TABLE_SCHEMA = '<owner Name'
and	a.TABLE_NAME = '<table Name>'
and	a.CONSTRAINT_TYPE = '<constraint Type>'
order by b.ordinal_position