How Delete all Tables of database Record?
- MS Sql Server
- 787
- 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
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
you can view the more detail via link https://www.youtube.com/watch?v=HpZgwHU1GcIChing xang
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Danial Comb
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!