SELECT NAME , OBJECT_NAME(referenced_object_id) 
FROM sys.foreign_keys 
WHERE OBJECT_NAME(parent_object_id)='tb_name'

------解决方案--------------------
探讨


引用:

SQL code
SELECT NAME , OBJECT_NAME(referenced_object_id)
FROM sys.foreign_keys
WHERE OBJECT_NAME(parent_object_id)='tb_name'


大侠，这个SQL语句只能查询出主外键关系名 和外键表名   如何查询出一个表中的外键字段名呢？


------解决方案--------------------
select s.id,k.fkeyid,k.fkey,c.name from sysobjects s
	inner join sysforeignkeys k on k.constid=s.id
	inner join syscolumns c on c.id=k.fkeyid and k.fkey=c.colid
	where OBJECT_NAME(parent_obj)='tablename' and s.xtype='F'