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
- 34809 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
Can we check locks in database? If so, how can we do this lock check?
Which are the important points to note when multilanguage data is stored in a table?
Explain intellisense for query editing
How do I connect to sql server database?
What are the different normalization forms?
What are the advantages of policy management?
How self join is different from outer join?
How do I create a stored procedure in dbml?
How connect excel to sql server?
Differentiate between a local and a global temporary table?
What were the latest updates to SQL Azure service?
How do I port a number to sql server?
How does index makes search faster?
Explain transaction server auto commit?
How you would rewrite the sql query to return the customerid sorted numerically?
