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
- 34463 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
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
Where actually sql azure database is hosted?
What is sql server profiler?
Explain the purpose of indexes?
What is plan freezing?
What is a partition key?
where can you add custom error messages to sql server? : Sql server administration
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is difference between clustered index and non clustered index?
What is a collation?
What do you mean by a dependent functionality in a build?
what are the different stages of Report Processing?
Explain partitioned view?
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
How to create a new login name in ms sql server?
