SELECT *
FROM information_schema.constraint_column_usage a
LEFT OUTER JOIN information_schema.table_constraints b
ON a.CONSTRAINT_CATALOG = b.CONSTRAINT_CATALOG AND 
    a.CONSTRAINT_SCHEMA = b.CONSTRAINT_SCHEMA AND
    a.TABLE_CATALOG = b.TABLE_CATALOG AND
    a.TABLE_SCHEMA = b.TABLE_SCHEMA AND
    a.CONSTRAINT_NAME = b.CONSTRAINT_NAME
WHERE CONSTRAINT_TYPE IN ('FOREIGN KEY', 'UNIQUE')

SELECT b.name, b.object_id, b.parent_object_id, b.type_desc
FROM sys.all_objects a
INNER JOIN sys.key_constraints b
    ON a.object_id = b.parent_object_id
WHERE b.type_desc = 'UNIQUE_CONSTRAINT'
UNION ALL 
SELECT b.name, b.object_id, b.parent_object_id, b.type_desc
FROM sys.all_objects a
INNER JOIN sys.foreign_keys b
    ON a.object_id = b.parent_object_id
WHERE b.type_desc='FOREIGN_KEY_CONSTRAINT'