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
- 34448 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 two tables have the same primary key?
What is TDS(Tabular Data Stream) Gateway?
How can we determine what objects a user-defined function depends upon?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Explain the difference between cross join and full outer join?
What is the current limitation of the size of SQL Azure DB?
How to create a simple user defined function in ms sql server?
Differentiate between mongodb vs. Sql server?
Explain some stored procedure creating best practices or guidelines?
What is temporary table in sql server? Why we use temp table?
What are the different types of upgrades that can be performed in sql server?
Can you pass expressions to function parameters?
What is the use of keyword with encryption. Create a store procedure with encryption?
When to use null data driven subscription?
How do you identify a foreign key?
