Validation

Using validation to prevent errors
Open ModelSphere offers DBMS validations to prevent the most
common errors in Data Definition Language (DDL) generation. It is recommended to
validate the database information prior to interfacing with the database and make the
corrections if necessary.
To validate your database:
- Select the database and right-click it.
- From the pop-up menu, choose Validate
.
A report will be generated. It will give you the errors and hyperlinks will point to the concerned objects.
Common validation list (Generic)
The following validations are available on every database.
- Every object has a physical name.
a. Every object’s physical name’s length does not exceed the maximum
length.
b. Every object’s physical name contains only valid characters.
c. Every object’s physical name is not a word reserved by the corresponding
DBMS.
d. Every object’s physical name is unique inside the namespace.
- Every domain is bound to a type.
- Every column is bound to a type.
- Every table contains at least one column.
- Every primary, unique or foreign key columns does not exceed the maximum
number of columns .
- Every column bound to a type that requires a length has one.
- Every column bound to a type that requires a Nbr. decimals value has one.
- Every primary/unique/foreign index has no column with a forbidden type.
- Every trigger contains instructions.
- Every procedure contains instructions.
- Every check constraint contains instructions.
- Every view has a selection rule.