To Delete All Tables In A Database At a time Using One Query.
USE [database name]
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
Showing posts with label drop tables. Show all posts
Showing posts with label drop tables. Show all posts
Saturday, April 6, 2013
How To Delete All Tables In A Database Using sql
To Delete All Tables In A Database At a time Using One Query.
USE [database name]
EXEC sp_MSforeachtable @command1 = "DROP TABLE ?"
Subscribe to:
Posts (Atom)