How to delete a foreign key whose primary key's table already deleted

Question

1.00/5 (1 vote)

See more:

hi 2 all ,

I have a problem . i have a foreign key on my table . but the other table which related t this foreign key as a primary key has been deleted already . now i want to remove this foreign key .. but nothing happen ...
how can i delete this key .. pls tell me frnds ....

in detail

my table name is centerinfo
and foreign key on this table is "FK__TargetInf__Cente__0777106D"

and the table which related to this with primary -foreign key relation is "targetinfoold"

and this table(targetinfoold) already deleted ...

how to delete this foreign key now
?

Posted 5-Sep-13 20:32pm

GDdixit

Add a Solution

Comments

phil.o 6-Sep-13 2:35am

Please tag it correctly to the database system concerned (MySQL, SQL Server, PostGRE...) instead of ASP.NET ; this cannnot be an ASP.NET problem.
And please give us more details on both tables and fields involved in the process (nullable or not, cascade mode, etc.).

GDdixit 6-Sep-13 6:00am

OK ...
These are foreign keys ...

Table is referenced by foreign key ..

mfapp403_500db.dbo.[targetinfoold]: FK__TargetInf__Cente__0777106D
mfapp403_500db.dbo.ClientCRTReportInfo: FK__ClientCRT__Cente__7EE1CA6C
mfapp403_500db.dbo.DayOpenDayCloseInfo: FK__DayOpenDa__Cente__1C1D2798
mfapp403_500db.dbo.SubgroupInfo: FK__SubgroupI__Cente__058EC7FB
mfapp403_500db.dbo.targetinfOld2: FK__TargetInf__Cente__41399DAE
mfapp403_500db.dbo.TempPaymentShceduleInfo: FK__TempPayme__Cente__297722B6

in this first one i.e. "mfapp403_500db.dbo.[targetinfoold]: FK__TargetInf__Cente__0777106D"

has the relationship with the table "targetinfoold" . and this table (targetinfoold) already deleted from my database ...
and now when tried to delete some data from my " centerinfo " .. it can not be possible ..

how to solve this ...i hope u understand ...

phil.o 6-Sep-13 6:24am

More clear ; but I'm still waiting for knowing which database system ^^

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)

fresher sathish · Answer 1 · 2013-09-05T20:46:00

Solution 1

ALTER TABLE centerinfo DROP FOREIGN KEY "FK__TargetInf__Cente__0777106D" use this query . i think it is correct so just try but not in 100%.

Posted 5-Sep-13 20:46pm

fresher sathish

Dholakiya Ankit · Answer 2 · 2013-09-05T21:02:00

oh you have lots resources check this

http://stackoverflow.com/questions/3815674/delete-from-two-table-having-foreign-key-constraint[^]

http://en.wikipedia.org/wiki/Foreign_key[^]

http://www.w3schools.com/sql/sql_foreignkey.asp[^]

http://msdn.microsoft.com/en-us/library/ds1swzd3.aspx[^]

regards..:)