while creating table and giving foreign key constraint give the key word

write a query to delete similar records in different tables
with same structure

Question Posted / radha sri seshu.kolla

4 Answers
9577 Views
I also Faced
E-Mail Answers

Answer Posted / radha sri seshu.kolla

while creating table and giving foreign key constraint give
the key word 'on delete cascade'.automatically when the
record in the master table is delated the relaeted record
in the detail table will also be deleted.

Is This Answer Correct ?

3 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sqlerrm?

984

What are stored procedures used for?

1050

What is a crud api?

991

What is triggering circuit?

1105

Which is better trigger or stored procedure?

1014

What are the different ways to optimize a sql query?

988

Is sql similar to python?

1040

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2553

What is sql constant?

1101

How do I count duplicates in sql?

1176

What is compilation error in pl sql?

1024

What is rename in sql?

1017

What is the use of primary key?

1047

what is a record in a database ? : Sql dba

1104

Is oracle and sql same?

1077