Home » SQL & PL/SQL » SQL & PL/SQL » Foreignkey
Foreignkey [message #238491] Fri, 18 May 2007 05:59 Go to next message
Messages: 144
Registered: February 2007
Location: india
Senior Member


I have a dept table and emp table.emp table is deptno column is foreign key.dept table deptno column is primary key.i want to reorganise(insert new records or delete old records)in dept (parent) table .What can i do?Any ways are there?

Re: Foreignkey [message #238496 is a reply to message #238491] Fri, 18 May 2007 06:06 Go to previous message
Messages: 111
Registered: March 2007
Location: India
Senior Member
Do it by disabling the constraints or using CASCADE
Previous Topic: Holding tables
Next Topic: Question on indexes
Goto Forum:

Current Time: Mon Aug 21 01:39:04 CDT 2017

Total time taken to generate the page: 0.10845 seconds