SQL guide-delete indexes, tables, and databases

Delete Index

You can use the drop index statement to delete an index in an existing table.

Microsoft sqljet syntax (and Microsoft Access ):

DROP INDEX index_name ON table_name

Ms SQL Server syntax:

DROP INDEX table_name.index_name

IBM DB2 and Oracle and Syntax:

DROP INDEX index_name

MySQL Syntax:

ALTER TABLE table_name DROP INDEX index_name

-------------------------------------------

Delete Database

Delete a table (the table structure, attributes, and indexes will also be deleted)

DROP TABLE table_name

Delete A database:

DROP DATABASE database_name

-------------------------------------------

Trim Data Table

What if we only want to remove the data in the table and keep the table itself? You can use the truncate table command to delete only the data in the table)

TRUNCATE TABLE table_name