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, select the table you want to drop. You can select multiple tables at one time.
-
Right-click the table and click Drop, or click
.
- Click OK to confirm.