查找表被哪些其它表引用外键的方法

obclient> select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE where REFERENCED_TABLE_NAME='表名';

obclient> SELECT TABLE_NAME FROM dba_constraints where R_CONSTRAINT_NAME in
(SELECT CONSTRAINT_NAME FROM dba_constraints WHERE TABLE_NAME='表名');

obclient> SELECT B.TENANT_NAME,A.TABLE_NAME FROM __all_virtual_table A,__ALL_TENANT B WHERE TABLE_ID IN ( SELECT child_table_id FROM __all_virtual_foreign_key WHERE parent_table_id IN( SELECT TABLE_ID FROM __all_virtual_table WHERE table_name='表名')) AND A.TENANT_ID=B.TENANT_ID and b.TENANT_NAME='租户名';