Unique Constraint of oracle (user_indexes and user_ind_columns )
The tables: user_indexes and user_ind_columns
desc user_indexes;
desc user_ind_columns;
select * from user_indexes where table_name=upper('table name');
select * from user_ind_columns where index_name=upper('&index_name');
desc user_indexes;
desc user_ind_columns;
select * from user_indexes where table_name=upper('table name');
select * from user_ind_columns where index_name=upper('&index_name');
评论
发表评论