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
- 35007 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
What are the differences between web role and worker role?
What are the functions in sql server?
What are sub reports and how to create them?
How to fetch the next row from a cursor with a "fetch" statement?
Please illustrate physical database architecture? : SQL Server Architecture
Explain Geometry datatype in sql server 2008 with example
What are the main differences between #temp tables and @table variables and which one is preferred?
Do you know what is bit data type and whats the information that can be stored inside a bit column?
Explain an incremental backup?
What are data regions?
What is a non-clustered index?
How to create a dynamic cursor with the dynamic option?
Equi join and non equi join is possible with sql server?
What are the types of subscriptions in SQL Server replication?
Explain Geography datatype in SQL Server
