DROP and TRUNCATE command in SQL

Advertisements

This article based on Drop and Truncate command.You can delete an existing index in a table with the DROP statement.

DROP INDEX table_name.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