oracle 常用命令

1.添加主键、索引等

create table test1(c1 int not null, c2 varchar(20) not null);

alter table TEST.TEST1 add constraint "pk_ff_1" primary key("C1", "C2");
alter table TEST.TEST1 drop constranit "pk_ff_1"

create index i_ff_1 on "TEST".TEST1(c1,c2);
drop index i_ff_1;

 

2.