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'为外键的名称
如对本文有疑问, 点击进行留言回复!!
大数据学习hadoop3.1.3——kylin即席查询——Presto server安装
阿里巴巴资深架构师熬几个通宵肛出来的Spark+Hadoop+中台实战pdf
荐 nginx安装,make install报错: cannot create regular file启动报错find: “/lost+found”: 权限不够/opt/module/p
zabbix web页面打开提示Database error(已解决)
网友评论