DB/SQL

index, view 문

ej503 2022. 7. 2. 18:28
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