When you generate the physical database schema from a physical model, you can include table-level or column-level validation rules you have defined as part of the schema. The validation rule definitions are translated into schema statements and inserts the specified parameter information in the correct syntax.
When reverse engineering from a schema file, script, or system catalog, validation rules are imported and are attached to the appropriate table or column in the resulting model. The convention used to name imported validation rules is:
VALID_RULEn
where n is a sequential number starting at zero. The first validation rule encountered when reverse engineering is named VALID_RULE0, the next rule VALID_RULE1, and so forth, until the entire schema is processed.
The Column and Table Level Validation Table lists each option that you can select in schema generation to include column and table-level validation rules in the generated schema.
Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |