What is the use of CASCADE CONSTRAINTS?
When this clause is used with the DROP command, a parent table can be dropped even when a child table exists.
If you liked this question/asnwer, make sure you
Subscribe to KyaPoocha.com RSS feed!
BOOKMARK THIS : BlinkList | del.icio.us | Digg it | Furl | reddit | StumbleUpon | Yahoo MyWeb |
Related Interview Questions
Cascade Delete Property for Link ? 26.09.08
This property is to clear the relation or unmapped child date to be removed from the DB. Cascade Delete has 3 types of values. 1) None 2) Clear 3) Delete 1)...What is cascade? 29.08.08
Cascade is a method of defining the weight (importance) of individual styling rules thus allowing conflicting rules to be sorted out should such rules apply to...How will you activate/deactivate integrity constraints? 17.05.08
The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE CONSTRAINT / DISABLE CONSTRAINT....What is the cascade rule and how does it relate to deletions made with a subselect ? 01.04.08
The cascade rule will not allow deletions based on a subselect that references the same table from which the deletions are being made....What is cascade? 20.11.06
Cascade is a method of defining the weight (importance) of individual styling rules thus allowing conflicting rules to be sorted out should such rules apply to...What is the use of CASCADE CONSTRAINTS? 26.03.06
When this clause is used with the DROP command, a parent table can be dropped even when a child table exists....What is ON DELETE CASCADE ? 12.03.06
When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced pr...What is the use of CONSTRAINTS option in EXP command ? 12.03.06
A flag to indicate whether constraints on table need to be exported....What is schema 11.03.06
A database-inspired method for specifying constraints on XML documents using an XML-based language. Schemas address deficiencies in DTDs, such as the inability...What is cascade delete 11.03.06
A deletion that triggers another deletion. A cascade delete can be specified for an entity bean that has container-managed persistence....