Mysql classes for BE IT students Bangalore

[Edwige]

The DROP INDEX Statement
To delete an index in a table we can use the drop index statement.
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
The DROP TABLE Statement
The DROP TABLE statement is used to delete a particular table in the database.
DROP TABLE table_name

The DROP DATABASE Statement
The DROP DATABASE statement is used to delete a particular database.
DROP DATABASE database_name