how to delete data child tables and parent tables in database

Question

0.00/5 (No votes)

See more:

Hello,

how can i delete data child and parent tables with out delete their relationship.
is it possible...?
thanks in advance

Posted 14-Oct-11 2:29am

K N R

Add a Solution

2 solutions

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)

Simon_Whale · Answer 1 · 2011-10-14T02:58:00

Solution 2

You can't delete tables and keep the relationship if you want to keep the relationship you need to keep the tables and just delete the content!

Cascading Delete[^]

Posted 14-Oct-11 2:58am

Simon_Whale

Updated 14-Oct-11 2:59am

v2

Comments

K N R 14-Oct-11 9:03am

hey simon,
am not delete tables, only delete content.

Simon_Whale 14-Oct-11 9:04am

Updated the answer text.. Cascading delete is what you are after using.

Simon Bang Terkildsen 14-Oct-11 9:09am

Indeed, my 5

Simon_Whale 14-Oct-11 9:10am

Thanks Simon :)

Simon Bang Terkildsen 14-Oct-11 9:07am

Ahh ok, I get it now, delete content not tables :)
As Simon said cascade delete is an option and a simple and easy one. Another option is to delete the "child data" first then the parent(s).

K N R 14-Oct-11 9:06am

can you please explain me i am new about this requirement

Simon Bang Terkildsen · Answer 2 · 2011-10-14T02:33:00

Solution 1

No ofcourse not, if you delete the tables then there are no tables to have a relationship between.

Posted 14-Oct-11 2:33am

Simon Bang Terkildsen

Comments

K N R 14-Oct-11 8:55am

hey simon,
first to find child tables and find is their any relationship if their then find parent table. in this way is working or not..?
can you please help me.

Simon Bang Terkildsen 14-Oct-11 9:05am

Sorry, I don't think I understand what you're asking.
If you're asking if it is possible to find all tables that some random table has a relationship to then yes. But it's not easy however, but if you google t-sql table get relationships you should be able to find plenty of discussions about how you can do it, the first two hits seem promising.

K N R 15-Oct-11 5:04am

thanks for your solution