how to delete rows in main table records with foriegn key values

Question

1.00/5 (2 votes)

See more:

SQL-Server-2005

hello iam maintaing three tables
Maintable1,table2,table3
tables are created at desing time not by queries execute.
table2,table2 are the foreign key tables under Maintable1.

My question is tables created at desing time so how to delete a record from Maintable1 at design time.How to do this?

provide examples with screens or example site with screens

Posted 23-Aug-11 20:16pm

raheemvali

Add a Solution

Comments

_Maxxx_ 24-Aug-11 2:23am

It's not clear what you are asking. You say the tables are created at "design time" - do you mean that you have created the tables through SQL Management Studio, or perhaps by running some "Create table" sql?

say the primary key value of a record in your MainTable is 123, so you have a record in table2 with a column MainTable1Key and a value of 123, and the same in table3
Then you should
Delete from table2 where Maintable1Key = 123
Delete from table2 where Maintable1Key = 123
Delete from Maintable where Key = 123

You asked "provide examples with screens or example site with screens"
which I completely don't understand?

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)

Abhinav S · Answer 1 · 2011-08-23T20:19:00

Solution 1

When creating these table, use the CASCADE Delete option.
See
http://msdn.microsoft.com/en-us/library/aa933119%28v=sql.80%29.aspx[^]
http://www.java2s.com/Code/SQLServer/Constraints/DELETECASCADEandUPDATECASCADE.htm[^]

Posted 23-Aug-11 20:19pm

Abhinav S

*dan!sh* · Answer 2 · 2011-08-23T20:20:00

Solution 2

Not sure what you mean by design time.

You cannot delete the parent record if it is a foreign key in any other table. That is the way keys are supposed to work. You need to delete all the child records first and then the parent record.

Posted 23-Aug-11 20:20pm

dan!sh