Hi,
How to empty the database created?
Your question is not clear. Please elaborate
Sir,
I have created a database and there is data in it.. I need to empty all the data in all the tables in this database.. How do i empty it.. I do not want to keep truncating each and every table
Refer here
http://riteshshah.wordpress.com/2009/03/04/empty-all-table-or-delete-all-data-from-all-table-by-sp_msforeachtable-in-sql-server-2005/
© COPYRIGHT 2025 ASPSnippets.com ALL RIGHTS RESERVED.