Blog

DROP all tables from a Database

Posted by Suthish Nair in Blogs | SQL Server 2012 on Jan 30, 2012

DROP all tables from a Database

Tweet
489
0

0

 EXEC sp_MSforeachtable @cmd = "DROP TABLE ?"

This hidden stored procedure will drop all tables from existing database.

Related Blogs

post comment

Nevron Gauge for SharePoint

Become a Sponsor

More Blogs from this Blogger

I'm Sorry How to set TextBox value using jQuery.. Find Last Day of a Month Facebook C# Visual Studio ALM Rangers Social media site perfectly summarized... Some statistics about Windows Phone 7 Parallel C++ Tool from Intel for Windows and Linux Wishing you all a Happy Holi DROP all tables from a Database

Latest Blogs

Free Ride is Over for Desktop Developers in Visual Studio 11 DotNet developers most used application/tools launching through 'Run' 80-inch Windows 8 Tablet Data encapsulation Option to access the Column Names in Data table Open multiple windows in browser startup. (Multiple homepages option) I'm Sorry const and readonly Address, Binding and Contract in WCF JQuery Maxchars Plugin

Become a Sponsor