January 8, 2009 03:40pm pst

There are currently no qualifying experts in Interbase / Firebird

1. NickUpson 363,306
2. kacor 51,844
3. BAlexand... 39,502
4. hobbit72 27,954
5. Stummel 15,838
6. Limbeck 13,475
7. idt 12,791
8. Trekker72 9,840
9. phuocnh 7,650
10. Delphian 7,089
11. vowca 6,618
12. ziolko 6,500
13. Deesy 6,310
14. MicheleM... 6,293
15. tkalchev 6,201
16. imfallible 6,000
17. YodaMage 5,982
18. ezraa 5,922
19. thegroup 5,672
20. angelIII 5,600
21. Ustin19 4,500
22. chart11... 4,148
23. JDSkinner 4,114
24. TheLearn... 4,100
25. ee_rlee 4,000

10.26.2008 at 08:28AM PDT, ID: 23848555 | Points: 500

	[x] Attachment Details

How to delete record with foreign keys?

Zone:

Interbase / Firebird Database

I have a table that has records that may or may not have a foreign key to another record in the same table. How do I delete the records with foreign keys if I don't know they exist? (it's like a backward reference and there is no forward reference).

Start your 7 day free trial to see this answer

Top Expert:	NickUpson
Expert Since:	03/24/2000
Accepted Solutions:	464

NickUpson has been an Expert for 8 years 9 months, during which he has posted 1675 comments and answered 464 questions. NickUpson is just one of 103 experts in the Interbase / Firebird Database Zone.

Related Solutions

Keywords: foreign, record, foreign, backward, forward, tabl, record

#	Title
1	Secondary or Foreign Keys
2	How to make an optional foreign key to…
3	Foreign Key Constraint Question
4	Transactions and deleting records fro…
5	oracle, database, 10.2.0.3…
6	Foreign Keys with MySql DB

20081119-EE-VQP-47 / EE_QW_EXPERT_20070906