SQL revocation indexes, tables, and databases

SQL revocation indexes, tables, and databases

By using the DROP statement, you can easily delete indexes, tables, and databases.

SQL DROP INDEX Statement

We can use the DROP Index command to delete the index in the table.

Syntax for Microsoft Sqljet (and Microsoft Access):

DROP INDEX index_name on table_name

Syntax for MS SQL Server:

DROP INDEX Table_name.index_name

For IBM DB2 and Oracle syntax:

DROP INDEX index_name

Syntax for MySQL:

ALTER TABLE table_name DROP INDEX index_name

SQL DROP TABLE Statement

The DROP TABLE statement is used to delete tables (the structure, properties, and indexes of the table are also deleted):

DROP Table Name

SQL DROP DATABASE Statement

The DROP DATABASE statement is used to delete databases:

DROP database name

SQL TRUNCATE TABLE Statement

If we just need to get rid of the data in the table, but not delete the table itself, what should we do?

Please use the TRUNCATE Table command (delete only the data in the table):

TRUNCATE Table Name

SQL revocation indexes, tables, and databases