Use SQL drop to delete tables, databases, and indexes

Next let's take a look at our commonly used drop function. This is used in mysql mssql access to delete SQL drop statements, Delete tables, delete databases, and delete indexes. Let's take an example here.

Drop index Delete index

Access:Drop index index_name ON table_name

Mssql:Drop index table_name.index_name

Mysql index deletion:Alter table table_name drop index index_name

DB2/Oracle index deletion method:Drop index index_name

The index is deleted using drop. The following describes how to use drop to delete databases and data tables,

The methods for deleting tables in access/mysql/mssql/db2/oracle are the same, for example, drop table table_name.

Access/mysql/mssql/db2/oracle the methods for deleting databases are the same, for example: drop table database_name