The DROP statement is used to delete object in SQL, with the DROP statement we can remove index, tables and even databases easily.
DROP INDEX
The indexes of the table can be dropped by the using the following command.
SYNTAX for MS Access
SYNTAX for SQL SERVER
SYNTAX for Oracle
SYNTAX for MySQL
For various DBMS the respective statement will drop the indexes from the table.
TO DROP TABLES
To drop the tables from the database the following syntax is used and it is same for all DBMS.
SYNTAX
TRUNCATE
If we do not want to drop the complete table but only want to flush/delete the data inside it you can use the TRUNCATE statement.
SYNTAX
TO DROP Databases
To drop the complete database we can use the following method and is same across all DBMS.
SYNTAX