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
- 34817 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 sql profiler. What are the default templates with it? : sql server database administration
Can we call future method from trigger?
What are the advantages dts has over bcp?
How you can find out if an index is useful to the optimizer?
What are the types of database schema? : sql server analysis services, ssas
Can two tables have the same primary key?
What is perspective, have you ever created perspective? : sql server analysis services, ssas
How to create a login account in ms sql server to access the database engine using "create login" statements?
What is function of master database?
if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration
How can you insert values in multiple rows using one Insert statement?
What are different types of statement?
Explain what are the restrictions while creating batches in sql server?
What are the instances when triggers are appropriate?
Are all views updatable ?
