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