To delete a database object (tables, relations, forms, reports, queries, sort orders, filters, column views) follow these steps:
Go to Database Manager.
Right click on the object you wish to delete and select Delete from the menu.
You will be asked if you are sure that you want to proceed with the deletion. Click on Yes and the object will be deleted.
Note that when you delete a query, any query components you created when designing the query are retained under the relevant table name.