List primary and foreign keys for database

SELECT cast(f.name  AS varchar(255)) AS foreign_key_name
    , r.keycnt
    , cast(c.name AS  varchar(255)) AS foreign_table
    , cast(fc.name AS varchar(255)) AS  foreign_column_1
    , cast(fc2.name AS varchar(255)) AS foreign_column_2
    ,  cast(p.name AS varchar(255)) AS primary_table
    , cast(rc.name AS varchar(255))  AS primary_column_1
    , cast(rc2.name AS varchar(255)) AS  primary_column_2
    FROM sysobjects f
    INNER JOIN sysobjects c ON  f.parent_obj = c.id
    INNER JOIN sysreferences r ON f.id =  r.constid
    INNER JOIN sysobjects p ON r.rkeyid = p.id
    INNER  JOIN syscolumns rc ON r.rkeyid = rc.id AND r.rkey1 = rc.colid
    INNER  JOIN syscolumns fc ON r.fkeyid = fc.id AND r.fkey1 = fc.colid
    LEFT JOIN  syscolumns rc2 ON r.rkeyid = rc2.id AND r.rkey2 = rc.colid
    LEFT JOIN  syscolumns fc2 ON r.fkeyid = fc2.id AND r.fkey2 = fc.colid
    WHERE f.type =  'F'
 -- ORDER BY cast(p.name as varchar(255))
 ORDER BY primary_table