How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 35608 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
Can one drop a column from a table?
Equi join and non equi join is possible with sql server?
Is it possible to have clustered index on separate drive from original table location?
What is sql or structured query language?
How can I check that whether automatic statistic update is enabled or not?
What is a view in sql?
What is the primary use of the model database?
How to rebuild the master database?
what is the difference between openrowset and openquery?
List the ways in which dynamic sql can be executed?
How raid can influence database performance?
Does view occupy space?
What is a coalesce function?
How to connect php with different port numbers?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
