SQL DROP INDEX, DROP TABLE, and DROP DATABASE
In SQL, Indexes, tables, and databases can without much of a stretch be erased/evacuated with the DROP statement.
The DROP INDEX Statement
The DROP INDEX proclamation is utilized to erase a record in a database.
DROP INDEX Syntax for MS Access:
DROP INDEX Syntax for MS SQL Server:
DROP INDEX Syntax for DB2/Oracle:
DROP INDEX Syntax for MySQL:
The DROP TABLE Statement
The DROP TABLE articulation is utilized to erase a table.
The DROP DATABASE Statement
The DROP DATABASE articulation is utilized to erase a database.
The TRUNCATE TABLE Statement
What on the off chance that we just need to erase the information inside the table, and not the table itself?
Then, utilize the TRUNCATE TABLE statement: