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
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)
- Threads, locks, deadlocks, race conditions, and thread safety in multi-threaded code