不太明白你的意思,提供你一点1. SELECT o1.name AS PKTABLE_NAME, c1.name AS PKCOLUMN_NAME FROM sysforeignkeys f INNER JOIN sysobjects o1 ON f.rkeyid = o1.id INNER JOIN syscolumns c1 ON f.rkeyid = c1.id AND f.rkey = c1.colid返回的是表名和表中有的主键2. SELECT o2.name AS FKTABLE_NAME, c2.name AS FKCOLUMN_NAME FROM sysforeignkeys f INNER JOIN sysobjects o2 ON f.fkeyid = o2.id INNER JOIN syscolumns c2 ON f.fkeyid = c2.id AND f.fkey = c2.colid返回的是表名和表中有的外键接下来就找对应关系,然后确定插入的顺序
SELECT o1.name AS PKTABLE_NAME, c1.name AS PKCOLUMN_NAME FROM sysforeignkeys f INNER JOIN sysobjects o1 ON f.rkeyid = o1.id INNER JOIN syscolumns c1 ON f.rkeyid = c1.id AND f.rkey = c1.colid返回的是表名和表中有的主键2.
SELECT o2.name AS FKTABLE_NAME, c2.name AS FKCOLUMN_NAME
FROM sysforeignkeys f INNER JOIN
sysobjects o2 ON f.fkeyid = o2.id INNER JOIN
syscolumns c2 ON f.fkeyid = c2.id AND f.fkey = c2.colid返回的是表名和表中有的外键接下来就找对应关系,然后确定插入的顺序