create view (view name) as select 구문;
drop view view name;
create index tel_num_add
on insert_test (tel_num);
//create
alter table insert_test add index seq (seq);
//alter add
alter table insert_test drop index seq;
//alter drop
alter table insert_test add unique index seq (seq);
show index from insert_test;
//show
'DB > SQL' 카테고리의 다른 글
SQL constraint 제약조건 (fk, pk, unique, default, check) (0) | 2022.06.30 |
---|---|
DB index 정리 (0) | 2022.06.29 |
insert into on duplicate key update (oracle merge) function + DDL alter (0) | 2022.06.29 |
FD 함수적 종속성 (0) | 2022.06.28 |
SQL update, delete function 정리 (0) | 2022.06.28 |