Dropping a table

Syntax

DROP TABLE table_name

Example

DROP TABLE foo;

Caution: Use this command carefully. It will drop the table completely, both structure and content.

To delete table contents only, see TRUNCATE.

  • 35
  • 27-Jul-2015
  • 715 Views