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.