How to write query to Delete the records in child table
and corresponding records in parent table
- 11 Answers
- 32984 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
How to integrate the ssrs reports in application?
How many null values we can have in a unique key field in sql server?
Explain the various types of concurrency problem?
Explain some stored procedure creating best practices or guidelines?
What happens when transaction log is full?
What is an indexing strategy?
What is meant by referential integrity?
Does group by or order by come first?
What are “phantom rows”?
Define cross join in sql server joins?
What is extended stored procedures?
What is de-normalization in sql database administration? Give examples?
What command is used to delete a table from the database in the sql server and how?
What is meant by dirty read?
How to create a new login name in ms sql server?
