SQL DROP TABLE

SQL DROP TABLE statement to delete/drop the table structure, table data, defined constraints or index. But, before deleting any parent table, make sure child table also should have been already deleted. Otherwise, parent table can not be deleted due to its integrity.

Syntax

DROP TABLE table_name;

SQL> DROP TABLE users_info;

Table dropped.

SQL TRUNCATE TABLE

SQL TRUNCATE TABLE statement only delete all records in a table and your table keep exist. In this case your table is empty.

Syntax

TRUNCATE TABLE table_name;

SQL> TRUNCATE TABLE users_info;

Table truncated.

• « Previous
• Next »