How to delete a table with SQL Server Table Designer

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:

C# in Depth, 3rd EditionManaged Windows VPS Hosting

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.