创建测试表
create table IDX_TEST
(
id NUMBER(11),
name VARCHAR2(10),
phone CHAR(11)
)
对字段,name,phone 创建索引名为 IDX_TEST_NAME_PHONE
create unique index IDX_TEST_NAME_PHONE on IDX_TEST(name,phone);
删除索引 IDX_TEST_NAME_PHONE
drop index IDX_TEST_NAME_PHONE