write a query to delete similar records in different tables
with same structure
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 does t sql mean?
What are the different types of triggers?
How you improve the performance of sql*loader? : aql loader
What's the difference between inner join and left join?
What is crud diagram?
What are schema-level triggers?
Is sql database free?
How to assign sql query results to pl sql variables?
What is an example of translating a date into julian format?
what is a trigger in mysql? : Sql dba
what is the difference between inner and outer join? Explain with example. : Sql dba
What is pivot in sql?
What is the difference between count 1 and count (*) in a sql query?
What are the disadvantages of not performing database normalization?
Is null operator in sql?