oracle创建索引、唯一索引和唯一约束索引

创建索引（如果字段为大写，请大写）

CREATE INDEX index_p_exam_subject_id_name ON p_exam (SUBJECT_ID,EXAM_NAME);

删除索引
drop index index_p_exam_subject_id_name;

 

创建唯一索引

CREATE UNIQUE INDEX uni_cet4_112_zkzh_kssfz ON CET4_112 (zkzh,ks_sfz);

删除索引
DROP index uni_cet4_112_zkzh_kssfz;

 

创建唯一约束索引

ALTER TABLE CET4_112 ADD CONSTRAINT uni_zkzh_ks_sfz UNIQUE (zkzh, ks_sfz);

删除唯一约束索引

ALTER TABLE CET4_112 DROP CONSTRAINT uni_zkzh_xm;