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
- 34501 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 do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What are the underflow and overflow behaviors on float literals?
What is the New in SQL server 2008?
What is a ddl statement?
What are the different types of subquery?
Explain transaction server explicit transaction?
how can you attach more than 20 ldf files in sql server
Do you know what are the properties of the relational tables?
How to Check if table exists in sql server?
what are the different types of SSRS reports?
What is the difference between getdate and sysdatetime?
what is spatial nonclustered index
What is clustered vs nonclustered index?
Write an sql query to find first weekday of the month?
Explain what are the events recorded in a transaction log?
