 Related Questions Latest Answer : Integrity constraint is that which depend upon the parent and child relationship
in which parent column have the primary constraint and child column have the foreign
key constraint.
You cannot delete the any value from column that have foreign key ... Latest Answer : Referential integrity constraint is that which depend upon the parent and child relationship. In this one of the column have the primary key constraint
and one of the column of another table have the foreign key constraint. So you cannot delete ... Answered by Scott on 2005-05-12 10:18:34: Constraints are found under the USER_CONSTRAINTS table. Latest Answer : Correction to some answers aboveUser_Constraints is a view and not a table ... Latest Answer : Alter table modify constraint < constraintname> disable/enableexamplealter table CONTACT_US modify constraint CONTACT_US_UK disable; ... Using ROWID.CONSTRAINTS Latest Answer : by using the index and rowid ... Integrity constraint is a rule that restricts values to a column in a table. Latest Answer : Integrity constraint restricts values of a column so that only meaningful values as per the business logic of the table be entered into the column.Integrity constraints are of the following types:Not nullUniquePrimary KeyForeign Key (referential integrity)Check ... Maintaining data integrity through a set of rules that restrict the values of one or more columns of the tables based on the values of primary key or unique key of the referenced table. Latest Answer : foreign key constraints is know as referential integrity. which refers to a primary or ( unique ,not null) column ... When ON DELETE CASCADE is specified ORACLE maintains referential integrity by automatically removing dependent foreign key values if a referenced primary or unique key value is removed. Latest Answer : Does not consider parent-child relationship.On deletion of parent record child records are deleated automatically but vise versa is'nt true ... The integrity constraints are stored in USER_CONSTRAINTS. Latest Answer : user_constraints, dba_constraints, all_constraints ... The integrity constraints can be enabled or disabled by ALTER TABLE ENABLE constraint/DISABLE constraint. Latest Answer : alter table modify constraint disable/enable ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
