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 ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is sql comments?
What is mutating error in pl sql?
Are subqueries better than joins?
How can we make an if statement within a select statement?
what is the difference between nested subquery and correlated subquery?
Do foreign keys improve performance?
Can we insert data into view?
what is commit? : Sql dba
What can sql server reporting services do?
What are the different types of constraints?
What is mdb stand for?
What kind of join is join?
Is sql the best database?
Why do we use procedures in sql?
Can we commit inside a trigger?