How to: Delete Tables from a Database (Visual Database Tools)
You can delete a table from your database using Object Explorer.
Think carefully before you delete a table. If existing queries, views, user-defined functions, stored procedures, or programs refer to that table, the deletion will make these objects invalid.
To delete a table from the database
In Object Explorer, select the table you want to delete.
Right-click the table and choose Delete from the shortcut menu.
A message box prompts you to confirm the deletion. Click Yes.
Deleting a table automatically removes any relationships to it.