SQL DROP INDEX Keyword

Flash cards

Review the key moves

1/4

Core idea

What is the main idea behind SQL DROP INDEX Keyword?

Lesson checks

Short Mimo-style checks built from this lesson's code, terms, and sequence.

1Quick choice

Which statement best captures the main point of this lesson?

The DROP INDEX command is used to delete an index in a table.

MS Access

DROP INDEX
index_name
 ON
table_name
;

SQL Server

DROP INDEX
table_name
.
index_name
;

DB2/Oracle

DROP INDEX
index_name
;

MySQL

ALTER TABLE
table_name
DROP INDEX
index_name
;

SQL DROP DEFAULT Keyword

SQL DROP TABLE and TRUNCATE TABLE Keywords

Loading lesson path

SQL•SQL References