List of All tables and Foreign Keys

SELECT         (CASE

         WHEN OBJECTPROPERTY(CONSTID, 'CNSTISDISABLED') = 0 THEN 'ENABLED'

         ELSE 'DISABLED'

        END) AS STATUS,

         OBJECT_NAME(CONSTID) AS CONSTRAINT_NAME,

         OBJECT_NAME(FKEYID) AS TABLE_NAME,

        COL_NAME(FKEYID, FKEY) AS COLUMN_NAME,

         OBJECT_NAME(RKEYID) AS REFERENCED_TABLE_NAME,

         COL_NAME(RKEYID, RKEY) AS REFERENCED_COLUMN_NAME

FROM SYSFOREIGNKEYS

ORDER BY  TABLE_NAME, CONSTRAINT_NAME,REFERENCED_TABLE_NAME,  KEYNO

GO