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:
DROP INDEX index_name ON table_name
Used for MS SQL Server DROP INDEX syntax:
DROP INDEX table_name.index_name
For DB2 / Oracle of DROP INDEX syntax:
DROP INDEX index_name
DROP INDEX syntax for MySQL:
ALTER TABLE table_name DROP INDEX index_name
DROP TABLE statement
DROP TABLE statement to drop the table.
DROP TABLE table_name
DROP DATABASE statement
DROP DATABASE statement is used to delete a database.
DROP DATABASE database_name
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:
TRUNCATE TABLE table_name