Thursday, July 11, 2013

Drop whole database tables using single query

use following query : -
==================


use master

exec sp_MSforeachtable @Command1 = "DROP TABLE ?"

your whole database dables will drop instantly.

No comments:

Post a Comment