Oracle中检查外键是否有索引的SQL脚本分享
SELECT a.table_name, a.column_name, b.index_name,FROM all_constraints a, all_ind_columns b,WHERE a.constraint_type = ...
SELECT a.table_name, a.column_name, b.index_name,FROM all_constraints a, all_ind_columns b,WHERE a.constraint_type = ...