Drop Index
You can delete an existing index in a table with the DROP INDEX statement.
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 |
Syntax for IBM DB2 and Oracle:
DROP INDEX index_name |
Syntax for MySQL:
ALTER TABLE table_name DROP INDEX index_name |
Delete a Table or Database
To delete a table (the table structure, attributes, and indexes will also be deleted):
DROP TABLE table_name |
To delete a database:
DROP DATABASE database_name |
Truncate a Table
What if we only want to get rid of the data inside a table, and not the table itself? Use the TRUNCATE TABLE command (deletes only the data inside the table):
TRUNCATE TABLE table_name |
