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 ?'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment