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.