Interested to Buy Any Domain ? << Click Here >> for more details...
write a query to delete similar records in different tables
with same structure
- 4 Answers
- 9237 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
What are the advantages of stored procedure?
Is it possible to read/write files to-and-from PL/SQL?
describe mysql connection using mysql binary. : Sql dba
How do I know if I have sql express or standard?
How can you load microsoft excel data into oracle? : aql loader
What is %s in sql?
Is left join faster than inner join?
How do I run sql profiler?
What is a sql statement?
What is trigger in sql? Explain
Explain dml and ddl?
What are the types of variables use in pl sql?
what is heap table? : Sql dba
What is sql injection vulnerability?
What kind of join is join?
