Delete All Records From All Table Using C#

Question

1.43/5 (3 votes)

See more:

C#

C#4.0

How to delete all records from all tables in SQL or Access database by utility

Posted 22-May-14 2:09am

sandipthummar

Updated 22-May-14 2:24am

CHill60

v3

Add a Solution

Comments

[no name] 22-May-14 8:18am

You could try screaming at it.

3 solutions

Solution 1

Query for Delete All records from All Tables

C#

Exec sp_MSforeachtable 'Delete from ?'

Posted 22-May-14 2:14am

King Fisher

Comments

CHill60 22-May-14 8:28am

sp_MSforeachtable is an undocumented SQL Server procedure. Using undocumented features of any language or tool can set you up for problems if new versions of the product no longer provide it.

King Fisher 22-May-14 8:51am

A few Months Ago,I got this Solution When I look For the Query to Delete all Table Records.It Was Worked. :)

CHill60 22-May-14 8:53am

I know it works... just be wary if you upgrade - don't assume it will work in the next release of SQL Server for example. In this case it will probably stay around, but companies have been known to drop undocumented features without any notice.

King Fisher 22-May-14 8:54am

May I know the reason for the Downvote

http://www.codeproject.com/Answers/760953/how-to-remove-decimals-without-rounding-it#answer4

[no name] 22-May-14 8:58am

Probably for the exact same reason that everyone else that "answers" 3 year old questions that already have answers get down votes.

King Fisher 22-May-14 9:29am

But The Question is not Solved yet,can any one refer this link in future sir. :(

CHill60 22-May-14 9:56am

There were solutions posted to that question in 2011. Are you having a problem displaying the page perhaps? Sometimes they don't display immediately

[no name] 22-May-14 10:24am

So what? It's still a 3 year old question that already has the answer. Whether the OP has accepted the answer or is still interested or actually managed to learn programming themselves in the past 3 years is immaterial. The only reason to answer questions that old is to spam the site or to be a useless rep point monger.

CHill60 22-May-14 9:01am

Neither this post nor the link you provided are displaying a downvote??? Looking at your solution though I would/will have downvoted it for these reasons - 1 it's an answer to a 3 year old post that had already been adequately answered and 2 - the OP wanted the solution for a number not a varchar and 3 - you've relied on an implicit conversion by assigning a numeric to a varchar.

King Fisher 22-May-14 9:33am

yes I agree sir :)

Solution 2

check below link
http://stackoverflow.com/questions/685112/how-to-delete-data-in-all-ms-access-tables-at-once[^]

Posted 22-May-14 2:21am

DamithSL

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Accepted Answer · 2014-05-22T02:55:00

run this script in sql server

SQL

declare @tblname int 
declare tbl_cursor cursor for
select name from sys.tables 
open tbl_cursor
fetch next from tbl_cursor into @tblname
while @@FETCH_STATUS = 0
begin
	EXECUTE ('truncate table '+ @tblname) 
	fetch next from tbl_cursor into @tblname
end 
close tbl_cursor
deallocate tbl_cursor

delete-all-rows-from-all-tables/[^]