| DROP INDEX | การลบ Index |
|---|
subject:DROP INDEX
syntax:DROP INDEX table_name.index_name
content:ใช้ในการลบ Index
example:CREATE TABLE person ( id IDENTITY NOT NULL, firstname VARCHAR(120) NOT NULL, lastname VARCHAR(120) NOT NULL, age INT NOT NULL ); CREATE INDEX index_age ON TABLE ( age ASC ); DROP INDEX person.index_age