Can we delete master records from the parent table ? if yes justify

Questions by surender reddy g

Showing Answers 1 - 12 of 12 Answers

pravin more(Solapur)

  • Jan 24th, 2007
 

yeswe can delete master record from the parent table using cascade worddelete from employee cascade;

  Was this answer useful?  Yes

SHAMIK

  • Feb 27th, 2007
 

we can also delete a record in the master table if  the term [on delete set null] is used when creating the table and declaring a column foriegn key

PRASHANTKULAT

  • Mar 7th, 2007
 

We can delete record from Parent table. But to do so We have to delete records from child table

To do so You can write Trigger (Before delete trigger) on the Parent Table which will delete all the child records.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions