How to delete index in oracle

In Oracle, you can use the "drop index" statement to delete the index. The function of this statement is to delete the specified index. The syntax is "drop index index name;".

The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.

How to delete index in oracle

drop index index_name;

1. Create index

create index 索引名 on 表名(列名);

2. Delete index

drop index 索引名;

3. Create combined index

create index 索引名 on 表名(列名1,,列名2);

4, query index

--根据索引名，查询表索引字段
select * from user_ind_columns where index_name='索引名';
--根据表名，查询一张表的索引
select * from user_indexes where table_name='表名';

Recommended tutorial: "Oracle Tutorial"

The above is the detailed content of How to delete index in oracle. For more information, please follow other related articles on the PHP Chinese website!