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 limitations of identity column? : Transact sql
What do you mean by rowid?
How to move files from one directory to another in pl sql?
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
What is meant by temporal data?
how to drop an existing view in mysql? : Sql dba
What is scalar data type in pl sql?
Is t sql a programming language?
What are sql procedures?
What found sql?
What is pl sql block structure?
how to use 'mysql' to run sql statements? : Sql dba
What is primary and foreign key?
How do I find sql profiler?
What are stuff and replace function?