Delete Tables (Database Engine) from SQL Server Database

You can delete (drop) a table from your database in SQL Server by using SQL Server Management Studio or Transact-SQL.

1. Using SQL Server Management Studio

1.To delete a table from the database

2. In Object Explorer, select the table you want to delete.

3. Right-click the table and choose Delete from the shortcut menu.

4. A message box prompts you to confirm the deletion. Click Yes.

2.Using Transact-SQL

1. To delete a table in Query Editor

2. In Object Explorer, connect to an instance of Database Engine.

3. On the Standard bar, click New Query.

Write following query in query window and click Execute.

DROP TABLE dbo.tablename;

Friends, If you like this post, please share with your friends on Facebook and Google+ and recommend us on Google using the g+1 button on the top right hand corner.