Código
DECLARE @NombreTabla AS VARCHAR(50); SET @NombreTabla = 'tblUsuario'; SELECT FK.TABLE_NAME AS 'Nombre Tabla', CU.COLUMN_NAME AS 'Columna Llave Foranea', PK.TABLE_NAME AS 'Tabla Llave Primaria', PT.COLUMN_NAME AS 'Columna Llave Primaria', C.CONSTRAINT_NAME AS 'Entidad Relación' FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME INNER JOIN( SELECT TC.TABLE_NAME, CU.COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON TC.CONSTRAINT_NAME = CU.CONSTRAINT_NAME WHERE TC.CONSTRAINT_TYPE = 'PRIMARY KEY' ) PT ON PT.TABLE_NAME = PK.TABLE_NAME WHERE PK.TABLE_NAME = @NombreTabla
No te olvides del punto y coma que separa las consultas