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 is int identity in sql?
How do you optimize a query?
What is rename command in sql?
What are the different type of joins in sql?
what is the use of friend function? : Sql dba
What is db journal file?
Can we join two tables without common column?
Can we join same table in sql?
Does pl/sql support create command?
What is the purpose of my sql?
What is mutating table error?
What is pl sql variable?
What are records give examples?
What type of join is sql join?
What is the most restrictive isolation level? : Transact sql