728x90 웹개발/SQL2 [SQL] 23.04.17 인덱스 alter table usertbl drop primary key; //테이블의 구조가 바뀌는것. create schema testdb; drop schema testdb; create table tbl1( a int primary key, b int, c int); show index from tbl1; create table tbl2( a int primary key, b int unique, c int unique, d int); show index from tbl2; create table tbl3( a int unique, b int unique, c int unique, d int); show index from tbl3; create table tbl4( a int unique not.. 2023. 4. 17. [SQL] DBMS 23.04.14 2023. 4. 14. 이전 1 다음 728x90