Databases Reference
In-Depth Information
We get a message confirming the
TRUNCATE
statement (the MySQL statement used
to quickly empty a table). Emptying a table can also be done in Table view with the
Empty
link located on the top menu:
Deleting data, either row-by-row or by emptying a table, is
a permanent action. No recovery is then possible except by
using a backup.
Deleting All Rows in Many Tables
The screen before last shows a checkbox to the left of each table name. We can choose
some tables, then in the
With selected
menu, choose the
Empty
operation as shown
in the following screen:
Of course, this decision must not be taken lightly!
Deleting Tables
Deleting a table erases the data
and
the table's structure. We can delete tables using
the
Drop
link in Table view:
Search WWH ::
Custom Search