How Delete all Tables of database Record?
- MS Sql Server
- 927
- March-28-2018
- by Rizwan Saqib
This Query special for Delete large amount of data of data base .For example there is 50 tables in Database and want to delete all record of 50 tables then we use this querey
sp_msforeachtable 'delete ?'
Note:
Be carefull this Query only Delete for all tables of database not for a single Tabel of database
