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
- 34933 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
Why are you getting errors when creating a new odbc dsn?
How many joins in sql server?
What is DCL?
What is the function of sql server agent windows service?
Can you please differentiate between a primary key and a unique key?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
How to find Duplicate Records In table?
How to configure and test odbc dsn settings?
What are data files?
write an SQL query to list the employees who joined in the month of January?
Is truncate a dml command?
Explain indexes disadvantages?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What are the different types of subquery?
What is sparse columns of sql server 2008?
