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
- 9384 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
Is it possible to create the following trigger: before or after update trigger for each row?
how to add a new column to an existing table in mysql? : Sql dba
What port does sql server use?
What are the features of pl sql?
how to decrement dates by 1 in mysql? : Sql dba
What is left join in postgresql?
What is a native sql query?
How many columns should be in an index?
How do I restart sql?
How does cross join work in sql?
What does partition by mean in sql?
What are instead of triggers?
What is embedded sql in db2?
How do I save a stored procedure?
What does rownum mean in sql?
