SELECT T1.name[约束名],T3.name[外键表],T4.name[外键列名] ,T5.name[主键表],T6.name[主键列名] FROM SYS.FOREIGN_KEYS T1 JOIN SYS.FOREIGN_KEY_COLUMNS T2 ON T1.parent_object_id=T2.parent_object_id JOIN SYS.SYSOBJECTS T3 ON T1.parent_object_id=T3.id JOIN SYS.SYSCOLUMNS T4 ON T2.parent_object_id=T4.id AND T2.parent_column_id=T4.colid JOIN SYS.SYSOBJECTS T5 ON T1.referenced_object_id=T5.id JOIN SYS.SYSCOLUMNS T6 ON T2.referenced_object_id=T6.id AND T2.referenced_column_id=T6.colid WHERE T1.parent_object_id=OBJECT_ID('student')
刚才又看了看,貌似还有些问题,就是明明只有2个外键,却查出来4条信息,2条对的,2条错的 截图中选中的两条蓝色背景的信息是正确的,请帮忙解决下。谢谢 SELECT T1.name[约束名],T1.referenced_object_id,T3.name[外键表],T4.name[外键列名] ,T5.name[主键表],T6.name[主键列名] FROM SYS.FOREIGN_KEYS T1 JOIN SYS.FOREIGN_KEY_COLUMNS T2 ON T1.object_id=T2.constraint_object_id JOIN SYS.SYSOBJECTS T3 ON T1.parent_object_id=T3.id JOIN SYS.SYSCOLUMNS T4 ON T2.parent_object_id=T4.id AND T2.parent_column_id=T4.colid JOIN SYS.SYSOBJECTS T5 ON T1.referenced_object_id=T5.id JOIN SYS.SYSCOLUMNS T6 ON T2.referenced_object_id=T6.id AND T2.referenced_column_id=T6.colid WHERE T1.parent_object_id=OBJECT_ID('student')try this
刚才又看了看,貌似还有些问题,就是明明只有2个外键,却查出来4条信息,2条对的,2条错的 截图中选中的两条蓝色背景的信息是正确的,请帮忙解决下。谢谢 SELECT T1.name[约束名],T1.referenced_object_id,T3.name[外键表],T4.name[外键列名] ,T5.name[主键表],T6.name[主键列名] FROM SYS.FOREIGN_KEYS T1 JOIN SYS.FOREIGN_KEY_COLUMNS T2 ON T1.object_id=T2.constraint_object_id JOIN SYS.SYSOBJECTS T3 ON T1.parent_object_id=T3.id JOIN SYS.SYSCOLUMNS T4 ON T2.parent_object_id=T4.id AND T2.parent_column_id=T4.colid JOIN SYS.SYSOBJECTS T5 ON T1.referenced_object_id=T5.id JOIN SYS.SYSCOLUMNS T6 ON T2.referenced_object_id=T6.id AND T2.referenced_column_id=T6.colid WHERE T1.parent_object_id=OBJECT_ID('student')try this这次可以了,再次感谢!
,T5.name[主键表],T6.name[主键列名]
FROM SYS.FOREIGN_KEYS T1
JOIN SYS.FOREIGN_KEY_COLUMNS T2 ON T1.parent_object_id=T2.parent_object_id
JOIN SYS.SYSOBJECTS T3 ON T1.parent_object_id=T3.id
JOIN SYS.SYSCOLUMNS T4 ON T2.parent_object_id=T4.id AND T2.parent_column_id=T4.colid
JOIN SYS.SYSOBJECTS T5 ON T1.referenced_object_id=T5.id
JOIN SYS.SYSCOLUMNS T6 ON T2.referenced_object_id=T6.id AND T2.referenced_column_id=T6.colid
WHERE T1.parent_object_id=OBJECT_ID('student')
刚才又看了看,貌似还有些问题,就是明明只有2个外键,却查出来4条信息,2条对的,2条错的
截图中选中的两条蓝色背景的信息是正确的,请帮忙解决下。谢谢
SELECT T1.name[约束名],T1.referenced_object_id,T3.name[外键表],T4.name[外键列名]
,T5.name[主键表],T6.name[主键列名]
FROM SYS.FOREIGN_KEYS T1
JOIN SYS.FOREIGN_KEY_COLUMNS T2 ON T1.object_id=T2.constraint_object_id
JOIN SYS.SYSOBJECTS T3 ON T1.parent_object_id=T3.id
JOIN SYS.SYSCOLUMNS T4 ON T2.parent_object_id=T4.id AND T2.parent_column_id=T4.colid
JOIN SYS.SYSOBJECTS T5 ON T1.referenced_object_id=T5.id
JOIN SYS.SYSCOLUMNS T6 ON T2.referenced_object_id=T6.id AND T2.referenced_column_id=T6.colid
WHERE T1.parent_object_id=OBJECT_ID('student')try this
刚才又看了看,貌似还有些问题,就是明明只有2个外键,却查出来4条信息,2条对的,2条错的
截图中选中的两条蓝色背景的信息是正确的,请帮忙解决下。谢谢
SELECT T1.name[约束名],T1.referenced_object_id,T3.name[外键表],T4.name[外键列名]
,T5.name[主键表],T6.name[主键列名]
FROM SYS.FOREIGN_KEYS T1
JOIN SYS.FOREIGN_KEY_COLUMNS T2 ON T1.object_id=T2.constraint_object_id
JOIN SYS.SYSOBJECTS T3 ON T1.parent_object_id=T3.id
JOIN SYS.SYSCOLUMNS T4 ON T2.parent_object_id=T4.id AND T2.parent_column_id=T4.colid
JOIN SYS.SYSOBJECTS T5 ON T1.referenced_object_id=T5.id
JOIN SYS.SYSCOLUMNS T6 ON T2.referenced_object_id=T6.id AND T2.referenced_column_id=T6.colid
WHERE T1.parent_object_id=OBJECT_ID('student')try this这次可以了,再次感谢!