sqlserver 取得外键关联表名

1. ?获取表修改时间：SELECT modify_date FROM SYS.OBJECTS WHERE object_id=OBJECT_ID('table_Name')
2. SELECT

? 外键表ID?? = b.fkeyid ,
? 外键表名称 = object_name(b.fkeyid) ,
? 外键列ID?? = b.fkey ,
? 外键列名?? = (SELECT name FROM syscolumns WHERE colid = b.fkey AND id = b.fkeyid) ,
? 主键表ID?? = b.rkeyid ,
? 主键表名?? = object_name(b.rkeyid) ,
? 主键列ID?? = b.rkey ,
? 主键列名?? = (SELECT name FROM syscolumns WHERE colid = b.rkey AND id = b.rkeyid) ,
? 级联更新?? = ObjectProperty(a.id,'CnstIsUpdateCascade') ,
? 级联删除?? = ObjectProperty(a.id,'CnstIsDeleteCascade')
FROM sysobjects a
? join sysforeignkeys b on a.id = b.constid
? join sysobjects c on a.parent_obj = c.id
where a.xtype = 'f' AND c.xtype = 'U'