select user_cons_columns.constraint_name as 约束名,
user_cons_columns.table_name as 子表名,
user_cons_columns.column_name as 子表列名,
user_cons_columns.position as 位置,
user_indexes.table_name as 主表名,
user_ind_columns.column_name as 主表列名
from user_constraints
join user_cons_columns
on (user_constraints.constraint_name =
user_cons_columns.constraint_name)
join user_indexes
on (user_constraints.r_constraint_name = user_indexes.index_name)
join user_ind_columns
on (user_indexes.index_name = user_ind_columns.index_name)
where/* constraint_type = 'r' and */ upper(user_indexes.table_name) = upper('bd_billtype');
user_cons_columns.table_name as 子表名,
user_cons_columns.column_name as 子表列名,
user_cons_columns.position as 位置,
user_indexes.table_name as 主表名,
user_ind_columns.column_name as 主表列名
from user_constraints
join user_cons_columns
on (user_constraints.constraint_name =
user_cons_columns.constraint_name)
join user_indexes
on (user_constraints.r_constraint_name = user_indexes.index_name)
join user_ind_columns
on (user_indexes.index_name = user_ind_columns.index_name)
where/* constraint_type = 'r' and */ upper(user_indexes.table_name) = upper('bd_billtype');