Monthly Archives: November 2011

Referential and Self-Referential Integrity Constraints

Referential Integrity Constraints Different tables in a relational database can be related by common columns, and the rules that govern the relationship of the columns must be maintained. Referential integrity rules guarantee that these relationships are preserved. Table lists terms … Continue reading

Posted in Uncategorized | Tagged , , | Leave a comment

Data Integrity Rules

Data Integrity Rules: The rules that can be applied to table columns to enforce different types of data integrity. Null rule: A null rule is a rule defined on a single column that allows or disallows inserts or updates of … Continue reading

Posted in Uncategorized | Tagged , | Leave a comment

Finding a constraint in Oracle

…where “X” is the constraint name I’m looking for For more detailed explanations http://www.databasejournal.com/features/oracle/article.php/3665591/Finding-Foreign-Key-Constraints-in-Oracle.htm

Posted in Uncategorized | Tagged , , | Leave a comment