SQL CREATE INDEX Statement
SQL CREATE INDEX Statement
인덱스를 생성하기
CREATE INDEX index_name
ON table_name (column1, column2, ...);CREATE INDEX Example
CREATE INDEX idx_lastname
ON Persons (LastName);DROP INDEX Statement
DROP INDEX index_name ON table_name;'Computer Science > Database' 카테고리의 다른 글
| W3Schools SQL | #52 SQL WORKING WITH DATES 날짜 이용법 (0) | 2022.10.30 |
|---|---|
| W3Schools SQL | #51 SQL AUTO INCREMENT 필드 (0) | 2022.10.30 |
| W3Schools SQL | #49 SQL DEFAULT CONSTRAINT 이용법 (0) | 2022.10.30 |
| W3Schools SQL | #48 SQL CHECK CONSTRAINT (0) | 2022.10.30 |
| W3Schools SQL | #47 SQL FOREIGN KEY CONSTRAINT 이용법 (0) | 2022.10.30 |