This SQL server tutorial explains 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:
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.
Your hosting company should support SQL 2008 Web hosting to host ASP.NET with MS SQL 2008.