shotaK/Drop all the tables from DB

Created June 1, 2016 11:30

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/shotaK/47ca8a5e5b9326d81e240f903e119465.js"></script>
Save shotaK/47ca8a5e5b9326d81e240f903e119465 to your computer and use it in GitHub Desktop.

Download ZIP

SQL

Raw

Drop all the tables from DB

EXEC sp_MSforeachtable @command1 = "DROP TABLE ?";

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment