Interested to Buy Any Domain ? << Click Here >> for more details...
How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 34913 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / chaitanya
***********
Delete from P_table where P_Id=C_Id
***********
This is only aplicable if you have defined the foreign key
in the child table with the constraint on Delete Cascade.
Else you will get a Integration error.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Tell me what do you understand by a view? What does the with check option clause for a view do?
What happens when the SQL Azure database reaches Max Size?
List the advantages of using stored procedures?
what is memory-optimized nonclustered indexes
How can you insert null values in a column while inserting the data?
How to create a simple table to test triggers in ms sql server?
How to run queries with sql server management studio express?
How many types of triggers are there?
What is the difference between locking and multi-versioning?
how many type of indexing in database?
What is the filtered index?
What is Dependency Injection and provide example?
What is scan table/view and seek table/view when its occurs? : sql server database administration
Can we use custom code in ssrs?
what is bit datatype? : Sql server database administration
