SELECT
c.TABLE_NAME,
c.COLUMN_NAME,
tc.CONSTRAINT_TYPE,
OBJECT_NAME(fkc.referenced_object_id) AS ReferencedTable,
COL_NAME(fkc.referenced_object_id,fkc.referenced_column_id) AS ReferencedColumn
FROM INFORMATION_SCHEMA.COLUMNS c
LEFT JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE kcu
ON c.COLUMN_NAME = kcu.COLUMN_NAME
AND c.TABLE_NAME = kcu.TABLE_NAME
AND c.TABLE_SCHEMA = kcu.TABLE_SCHEMA
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc
ON tc.TABLE_NAME = c.TABLE_NAME
AND tc.TABLE_SCHEMA = c.TABLE_SCHEMA
AND tc.CONSTRAINT_TYPE IN ('PRIMARY KEY','FOREIGN KEY')
LEFT JOIN sys.foreign_key_columns fkc
ON OBJECT_NAME(fkc.parent_object_id) = c.TABLE_NAME
AND COL_NAME(fkc.parent_object_id,fkc.parent_column_id)=c.COLUMN_NAME
WHERE c.TABLE_NAME='your table name here'