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
- 35306 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
Describe how to use the linked server?
What is update locks?
You want to implement the one-to-one relationship while designing tables. How would you do it?
How to list all tables in the database using odbc_tables()?
How adventureworkslt tables are related?
What is meant by dirty read?
Please differentiate between a local and a global temporary table?
What are commonly used mssql functions in php?
Explain insert into select statement?
Explain what is analysis service repository?
What is a derived table?
Define cursor locking
How to convert numeric expression data types using the cast() function?
Which trace flags are enabled in sql server?
What is the definition for sql server 2000?
