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
- 9562 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 is the difference between subquery and correlated query?
How many joins in sql?
What is primary key and foreign key?
Is primary key clustered index?
What is the best partition size for windows 10?
How many databases can sql express handle?
How to create a menu in sqlplus or pl/sql?
What are the qualities of 2nf?
What are the two virtual tables available at the time of database trigger execution?
How can I tell if sql is running?
What normalization means?
what is an extent ? : Sql dba
what is a foreign key ? : Sql dba
How many sql are there?
Does inner join return duplicate rows?
