Deleting or dropping a table lets you remove
an unnecessary table from the database.
This example shows you how
to delete the office table from the demo database.
Right-click
the office table, and choose Delete. 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.