write a query to delete similar records in particular
fields(columns) in different tables
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 ? | 5 Yes | 1 No |
Post New Answer View All Answers
what are the different type of normalization? : Sql dba
How can get second highest salary in sql?
What is pivot query?
What is sql partition function?
how to drop an existing view in mysql? : Sql dba
Does pl sql work in mysql?
What is a primary key sql?
Is vs as in pl sql?
What are different types of queries in sql?
What are pl sql data types?
What is the difference between clustered and non-clustered index in sql?
What is embedded sql what are its advantages?
What is dynamic query?
Which nosql database is best?
What is the benefit of foreign key?