Tables can be deleted, or dropped, from a database. The office table created in a previous section can be dropped from the demo database, restoring the database to its original state.
Deleting 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.