How can i delete the foreign key records in Table2 when i delete it's
Primary key on Table1?
Edwin
by Edwin Ma » Sat, 25 Sep 1999 04:00:00
Edwin
by Charles Bretana Jr » Sat, 25 Sep 1999 04:00:00
Delete ChildTable
Delete ParentTable
Return (0)
Quote:> How can i delete the foreign key records in Table2 when i delete it's
> Primary key on Table1?
> Edwin
1. foreign key w/o foreign/primary key
Does anyone have an opinion on the most efficient way to check
referential integrity on a table where the would-be foreign key is
neither unique or primary? Would I use a check constraint? If so, how
without a subquery?
Thanks in advance,
Sent via Deja.com
http://www.deja.com/
2. Has anyone built a VERY large cube?
3. Selecting lowest foreign record for each primary key;
4. Distributed pages and large tables
5. DELETE RECORDS REGARDLESS FOREIGN KEYS
6. Strange results of aggregate function against view; okay against table
7. error in deleting a record which is foreign key
8. Oracle 8i Listener and Oracle 8i Listener
9. Primary key and Deleted Records
10. Deleting Records With Primary Keys
11. Foreign Key as subset of Primary Key
12. Identification of a primary key/foreign key
13. One FOREIGN KEY refrences a Table with two Primary Keys