Tables can be deleted, or dropped, from a database. The office table created in a previous section can be dropped from the sample database, restoring the database to its original state.
Deleting the office table from the sample database
Right-click the office table.
Select Delete from the submenu.
or
Left-click the table and press the Delete key or the Delete toolbar button.
You can delete proxy tables in the same way. If you try to delete a proxy table that was created with the new local remote option and the remote server is inaccessible, you get an error message indicating that the remote server is inaccessible.
WARNING! Deleting a proxy table that was created with the new local and remote table option also deletes the remote table. You will lose all data stored in the remote database.