oracle查询表的索引及字段,删除索引,创建索引
select S.index_name from user_indexes s where s.table_name='TEACHERNUMBERSET'SELECT s.column_name FROM user_ind_columns S WHERE S.index_name='IDX_TEACHNUM'drop index IDX_TEACHNUM;create unique...
原创
2019-10-15 16:41:05 ·
1246 阅读 ·
0 评论