SQL drop usage Deletes a table, deletes a database, deletes an index

Let's take a look at our commonly used drop functions, which are used to delete the SQL drop usage in MySQL access to delete the table, delete the database, delete the index Oh, let's step through the example.

Drop INDEX Delete Indexes

Access Deletes the index: DROP INDEX index_name on table_name

MSSQL Delete index: DROP INDEX Table_name.index_name

MySQL Delete index: ALTER TABLE table_name DROP INDEX index_name

db2/oracle Delete Index method: DROP INDEX index_name

The above is using drop to delete the index, the next we want to see how to use drop to delete the database and datasheet,

Access/mysql/mssql/db2/oracle Deletes a table in the same way as: DROP TABLE table_name

Access/mysql/mssql/db2/oracle Delete a database in the same way as: Drop TABLE database_name