how can we delete multiple table data with a single query statement

Question

0.00/5 (No votes)

See more:

hi all,
i have to delete multiple(two or three) table data rows with one query statement in sqlcommandquery with where condition. is it possible? if possible then how can we do it?

thanks in advance

Posted 10-Nov-11 22:02pm

mkcm2011

Add a Solution

6 solutions

Solution 5

Refer these links:
May help you

http://bytes.com/topic/access/answers/868502-delete-all-records-multiple-tables-one-shot[^]

http://dbaspot.com/sqlserver-faq/426606-delete-multiple-tables-single-query.html[^]

Posted 10-Nov-11 22:20pm

sravani.v

Solution 6

you need to write a store procedure for all deletes and need to pass all the parameters....it will work..

Posted 12-Nov-11 3:11am

Member 8034530

Solution 1

Yes you can, just supply the where filter :

SQL

DELETE FROM [tablename] where column1=9 or column2>2

Posted 10-Nov-11 22:09pm

Mehdi Gholam

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)

Rajesh Anuhya · Accepted Answer · 2011-11-10T22:14:00

Solution 2

Better to write a Stored Procedure, that accepts your all conditions
and execute your delete statements one by one or using transaction way.

Posted 10-Nov-11 22:14pm

Rajesh Anuhya

UJimbo · Accepted Answer · 2011-11-10T22:18:00

Solution 3

You have to write a delete statement for each Table. I believe it's not possible to delete from three tables using only one Where statement, unless there is a relationship between these tables allowing a Cascade Delete.

Posted 10-Nov-11 22:18pm

UJimbo

Comments

mkcm2011 11-Nov-11 4:28am

how to do it....i want to delete two table rows with where statement , where id is same ......they are in relationship like one have details of college student name age and all with id and other have their subjects marks with id. plz help me out

UJimbo 11-Nov-11 4:38am

http://www.dbasupport.com/forums/showthread.php?t=11441
It also explains how to setup two tables for a cascade delete, which means deleting the row in one table will also delete the row in the second table automatically.

Anil Honey 206 · Accepted Answer · 2011-11-10T22:20:00

Solution 4

Dear Friend,

Use StoredProcedure and Implement all methods What ever you Required if yo want to Delete total Data in Table use Truncate.

Regards,

Anilkumar.D

Posted 10-Nov-11 22:20pm

Anil Honey 206

Comments

mkcm2011 11-Nov-11 4:29am

thanks but how to do it...i want proper code