Knowledge about SQL Revocation indexes, tables, and databases

SQL revocation indexes, tables, and databases are important in PHP and are explained in this article.

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

This article on the SQL Revocation index, table and database-related knowledge, more learning materials clear focus on the PHP Chinese network can be viewed.