USE tuBaseDeDatos;
GO DECLARE @tabName AS Varchar(50)
SET @tabName = 'dbo.TU_TABLA'--table´s name from fk´s are goint to get
SELECT OBJECT_NAME(f.constid) AS 'FKName', c.name AS 'ColName'
FROM sysforeignkeys f INNER JOIN syscolumns c
ON f.fkeyid = c.id AND f.fkey = c.colid
WHERE fkeyid = OBJECT_ID(@tabName)