The following SQL will delete all the tables and their associated information from a database.
USE [database] EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
The only downside to this is that you cannot perform a rollback, so you need to make sure this is what you want to do. Otherwise, that's all there is to it. Just run this in a New Query Window in SQL Server Management Studio (SSMS) and you're done.
Related Posts
Multiple ASP.NET apps under the same host and port in Visual Studio with IIS Express and Webpack Dev Server Proxy- ViewModel constructors and inheritance by extending kendo.data.ObservableObject
Exploring Active Record as a base for business entities in a business logic layer with Entity Framework- Using your own database schema and classes with ASP.NET Core Identity and Entity Framework Core
- Using DataTestMethod and DataRow to pass parameters to a unit test and prevent duplicating test methods
- Building SSDT SSRS projects (.rptproj) with a build server (TeamCity)