Dotnet Programing
It provides the solution of any query about C# windows forms, Asp.net,HTML,CSS,Sql Server
Pages
Home
C# Interview Questions & Answers
Friday, January 17, 2014
Truncate All the table of Database and delete all the data of all the table from database
For truncate
USE MyDatabase
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'
For Delete
USE MyDatabase
EXEC sp_MSforeachtable 'DELETE FROM ?'
Newer Posts
Older Posts
Home
Subscribe to:
Posts (Atom)