How to drop all tables from database with one SQL query?

 How to drop all tables from database with one SQL query?

You can write query like this:

USE Databasename

SELECT  'DROP TABLE ' + name + ';'
FROM    sys.tables
You can copy and paste into a new SSMS window to run it.

Comments

Post a Comment

Popular posts from this blog

Network adapter does not showing in device manager

  Network adapter does not showing in device manager If all else fails, add a PCI or PCI-E Network card. That should fix the problem. 1.Before doing that though, open a Elevated Command Prompt. 2.Type set devmgr_show_nonpresent_devices=1 and press Enter. 3.Type devmgmt.msc and press Enter to open Device Manager. 4.Click on View then Show Hidden Devices.  5.Scroll down and see if Network Adapter is present now or if an Unknown Device shows up. Which ever it is, right click on it and select Uninstall. Reboot and see if Win 7 redetects the device and reloads the driver for it
Read more