‹ BACK

The DROP INDEX Statement

The DROP INDEX Statement

The DROP INDEX statement is used to delete an index in a table.
DROP INDEX Syntax for MS Access:
DROP INDEX index_name ON table_name
DROP INDEX Syntax for MS SQL Server:
DROP INDEX table_name.index_name
DROP INDEX Syntax for DB2/Oracle:
DROP INDEX index_name
DROP INDEX Syntax for MySQL:
ALTER TABLE table_name DROP INDEX index_name
Read more: SQL DROP
MySQL SQL-server Oracle DROP-statement DROP-INDEX DB2 MS-Access

To check your knowledge the following tests are recommended:
Check your sql sql skills.