Database Reference
In-Depth Information
Deleting all rows in many tables
The first screenshot under the previous section, 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:
In the Database view, we can delete a specific table by using the X-shaped icon for
that table. The same mechanism also exists for deleting more than one table (with the
drop-down menu and the
Drop
action).
The
Empty
and
Drop
actions are marked in red, to better indicate the
inherent danger of these actions on data.
Deleting databases
We can delete an entire database (including all its tables) using the
Drop
link in
Database view.
Search WWH ::
Custom Search