select 外键名称=b.name,外键关联的表='titles',外键所在的表=d.name,外键所在表列=f.name from sysobjects a join sysobjects b on a.id=b.parent_obj join sysforeignkeys c on b.id=c.constid join sysobjects d on c.rkeyid=d.id join sysindexkeys e on d.id=e.id join syscolumns f on a.id=f.id and e.colid=f.colid where a.name='titles' and b.xtype='f'
等了一会了
不知道会不会被凉起,没人解决~~~哎~~~~~~~~
join sysforeignkeys c on b.id=c.constid
join sysobjects d on c.rkeyid=d.id
join sysindexkeys e on d.id=e.id
join syscolumns f on a.id=f.id and e.colid=f.colid
where a.name='titles' and b.xtype='f'
from sysforeignkeys
from sysforeignkeys
第一次见到这种希奇古怪的方法
不过捎加改动,还真得可以,,太厉害了~~~~佩服之情由然而生,,,崇拜之心不复有加~~~仰慕之意不能言语
太厉害了@!@!!!!!!!!!!!!!!!!!!!!!!!