查看索引
show
index
from
sdn_system_operation;
创建唯一索引
create
unique
index
unique_index_operation_name
on
sdn_system_operation(operation_name);
create
unique
index
unique_index_operation_code
on
sdn_system_operation(operation_code);
create
unique
index
unique_index_operation_nameandcode
on
sdn_system_operation(operation_name,operation_code);
删除唯一索引
drop
index
unique_index_operation_name
on
sdn_system_operation;
drop
index
unique_index_operation_code
on
sdn_system_operation;
drop
index
unique_index_operation_nameandcode
on
sdn_system_operation;
将
UNIQUE
约束添加到已存在的表中
alter
table
sdn_system_operation
constraint
unique_index_operation_name
unique
(operation_name);
alter
table
sdn_system_operation
constraint
unique_index_operation_code
unique
(operation_code);
alter
table
sdn_system_operation
constraint
unique_index_operation_nameandcode
unique
(operation_name,operation_code);
解除唯一索引
alter
table
sdn_system_operation
drop
index
unique_index_operation_name;
alter
table
sdn_system_operation
drop
index
unique_index_operation_code;
alter
table
sdn_system_operation
drop
index
unique_index_operation_nameandcode;