SQL DROP INDEX, DROP TABLE, and DROP DATABASE
Indexes, tables, and databases can easily be deleted/removed with the DROP statement.
The DROP INDEX Statement
The DROP INDEX statement is used to delete an index in a table.
DROP INDEX Syntax for MS Access:
| DROP INDEX index_name ON table_name |
DROP INDEX Syntax for MS SQL Server:
| DROP INDEX table_name.index_name |
DROP INDEX Syntax for DB2/Oracle:
DROP INDEX Syntax for MySQL:
| ALTER TABLE table_name DROP INDEX index_name |
The DROP TABLE Statement
The DROP TABLE statement is used to delete a table.
The DROP DATABASE Statement
The DROP DATABASE statement is used to delete a database.
| DROP DATABASE database_name |
The TRUNCATE TABLE Statement
What if we only want to delete the data inside the table, and not the table itself?
Then, use the TRUNCATE TABLE statement:
| TRUNCATE TABLE table_name |
Click here to design a Stunning Flash Website for Free
Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.
With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.
| 
