How to write query to Delete the records in child table
and corresponding records in parent table
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 a coalesce function?
How to add an address record into adventureworkslt?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
Explain relational data?
What do you understand by integration services in sql server?
What does nvl stand for?
can any body tell me how to know the password of current user in sql server
How to get the definition of a stored procedure back?
What are sub reports?
What are the different types of backups avaialabe in sql server 2005?
How do I find the transaction log size in sql server?
What are the rules to use the rowguidcol property to define a globally unique identifier column?
Can you please explain the difference between function and stored procedure?
Explain full-text indexing?
What are the components of sql server service broker?