SQL revocation indexes, tables, and database
By using the DROP statement, you can easily delete indexes, tables and databases.
DROP INDEX statement
DROP INDEX statement deletes an index for the table.
DROP INDEX Syntax for MS Access is:
Used for MS SQL Server DROP INDEX syntax:
For DB2 / Oracle of DROP INDEX syntax:
DROP INDEX syntax for MySQL:
DROP TABLE statement
DROP TABLE statement to drop the table.
DROP DATABASE statement
DROP DATABASE statement is used to delete a database.
TRUNCATE TABLE statement
If we only need to delete data within a table, but does not delete the table itself, then we are going to help them?
Please use the TRUNCATE TABLE statement: