How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 33034 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / arijitnit
delete from child_table where values=...
on delete cascade..
U have to set the foreign key as the parent super key
| Is This Answer Correct ? | 11 Yes | 7 No |
Post New Answer View All Answers
What is a file group?
What is exporting and importing utility?
Can we shrink data file in sql server?
How to change the password of a login name in ms sql server?
Where are sql server user names and passwords stored in sql server?
How to find out what is the default collation in a database?
How to get the definition of a user defined function back?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
List the various tools available for performance tuning?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Tell me what is the stuff and how does it differ from the replace function?
What is the temp table?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
What is parameterized reports in ssrs ?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
