Developer can use Table Designer in SQL Server “Denali”,  MS SQL Server 2008 R2 and MS SQL Server 2005 to delete a table from the existing database by following the next steps:

1. In Object Explorer selects the table he/she wants to delete.

2. Right-clicks the table and chooses Delete from the shortcut menu.

3. A message box prompts him/her to confirm the deletion. Clicks Yes.

Note: Developer should check in advance if existing database objects as queries, views, user-defined functions, stored procedures, or programs refer to the table which will be deleted. If some of these objects refer to that table, the deletion will make them invalid.