write a query to delete similar records in particular
fields(columns) in different tables
- 6 Answers
- 11805 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / ram
Guys, Please see the question again. It is related to
deleting different tables. I guess, the question is
intented to get the answer - ON DELETE CASCADE. We give
foreign constraints on tables and when the parent record is
deleted, the child records are automatically deleted when
you give command as ON DELETE CASCADE
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Why does sql need a server?
What is implicit cursor in pl sql?
How do I partition in sql?
How to return multiple rows from the stored procedure?
Can we create index on primary key?
What is sql clause?
What is a variable in sql?
Which join is default?
what are the drivers in mysql? : Sql dba
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
How you improve the performance of sql*loader? : aql loader
what is query cache in mysql? : Sql dba
How is data stored on a disk?
What is the difference between row level and statement level trigger?
what is a composite primary key ? : Sql dba
