Delete all tables from Sql server Database

Introduction:

 In this article i will explain the command for how to delete all the tables from Sql Server database with SQL query.

Note: The command will delete all the tables from the database so use with care.Here is the command:


Implementation: In sql server execute the following command:

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"