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
- 35008 Views
- Semantic Space, I also Faced
- E-Mail Answers
Answer Posted / krishnakumar
create table employee(id int references authors(au_id) ON
DELETE CASCADE,firstname(30))
this is chilld table .in this query use on first child table
constraints values delete next parent table constrains value
delete ... this is ON DELETE CASCADE CONCEPT
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What is the difference between resultset and resultsetmetadata?
What is policy based management (pbm)? : sql server database administration
Why olap is used?
What are the differences between sql server and mysql.
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
What are the 2 types of classifications of constraints in the sql server?
What is 3nf normalization?
What are binary string data types in ms sql server?
What is an execution plan?
How you trouble shoot when any job fails
Explain few examples of RDBMS?
What is the difference between nvl and nvl2?
How to return the top 5 rows from a select query in ms sql server?
What is ms sql server index?
What is difference between equi join and natural join?
