Interested to Buy Any Domain ? << Click Here >> for more details...
What is the cascade rule and how does it relate to
deletions made with a subselect?
- 1 Answers
- 5649 Views
- I also Faced
- E-Mail Answers
Answer Posted / s
Cascade deletes the foreign keys when the primary key is
delted.
When using subselect the rows deleted are based on the rows
that qualify for the subselect.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is copy pending and check pending in db2?
What is the maximum size of a char data type in db2?
What is dbrm? What it contains? When it will be created?
What is lock escalation in db2?
How can you count the number of rows from a table tab?
Name the lockable units in DB2?
How do you find the maximum value in a column in db2?
Where do you specify them?
What is multi row fetch in db2?
What is the max length of sqlca?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What parameters are used to control the free space in DB2?
Explain what are the various isolation levels possible?
