How Delete all Tables of database Record?
Microsoft Net Framework

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 

 

 

 

 

Share This with your friend by choosing any social account


Upcoming Articles
You may also read following recent Post
Copyright Future Minutes © 2015- 2024 All Rights Reserved.   Terms of Service  |   Privacy Policy |  Contact US|  Pages|  Whats new?
Update on: Dec 20 2023 05:10 PM