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