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
- 34973 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 are the components of dbms?
what is a correlated sub-query? : Sql server database administration
What are 3 ways to get a count of the number of records in a table?
What is ssrs?
What is log cache in sql server?
Write a SQL query to make a column as unique?
What is acid properties?
In case you have filters in your report, when filters will be applied in cached report instance?
What are different types of statement?
What are the restrictions applicable while creating views? : SQL Server Architecture
what protocol both networks use? : Sql server database administration
Explain logical operators in sql server?
Can I run multiple instances of sql server 2000 at the same time on one computer?
Explain what are page splits? : SQL Server Architecture
What are drilldown reports?
