select osub.name as [子表名称] , fk.name as [外键名称] , subcol.name as [子表列名] , omain.name as [主表名称] , maincol.name as [主表列名] from sys.foreign_keys fk join sys.all_objects osub on ( fk.parent_object_id = osub.object_id ) join sys.all_objects omain on ( fk.referenced_object_id = omain.object_id ) join sys.foreign_key_columns fkcols on ( fk.object_id = fkcols.constraint_object_id ) join sys.columns subcol on ( osub.object_id = subcol.object_id and fkcols.parent_column_id = subcol.column_id ) join sys.columns maincol on ( omain.object_id = maincol.object_id and fkcols.referenced_column_id = maincol.column_id ) where fk.name like '@fk_oee_defe_reference_system_ue';
‘@fk_oee_defe_reference_system_ue’为外键的名称