To drop a table, you must be the owner of the table. Dropping a table removes the table from the database, including all table rows, and any indexes and constraints that exist for the table.
-
In the Object List Viewer, right-click the table and select Drop.
You can select multiple tables at one time.
- Click OK to confirm the drop operation.