oracle数据库中查询该某个表的主键被哪些表引用及该表中的外键来
发布时间:2020-12-12 14:15:17 所属栏目:百科 来源:网络整理
导读:1.oracle中查询某个表中的主键被哪些表引用的SQL语句: SELECTc.TABLE_NAMEFROMall_constraints p,all_constraints cWHEREp.table_name = '表名'AND p. OWNER = SYS_CONTEXT ('USERENV','CURRENT_SCHEMA')AND c. OWNER = SYS_CONTEXT ('USERENV','CURRENT_SC
1.oracle中查询某个表中的主键被哪些表引用的SQL语句:
SELECT c.TABLE_NAME FROM all_constraints p,all_constraints c WHERE p.table_name = '表名' AND p. OWNER = SYS_CONTEXT ('USERENV','CURRENT_SCHEMA') AND c. OWNER = SYS_CONTEXT ('USERENV','CURRENT_SCHEMA') AND c.constraint_type = 'R' AND p.CONSTRAINT_NAME = c.R_CONSTRAINT_NAME 注:表名要带上单引号 2.oracle中查询该表中的外键来源于哪些表的SQL语句:
SELECT cl.table_name FROM user_cons_columns cl LEFT JOIN user_constraints c ON cl.constraint_name = c.r_constraint_name WHERE c.constraint_type = 'R' AND c.table_name = '表名' (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |