Prefixing Object Names
There is a schema concept for most DBMSs, which enables definition of a logical grouping for objects.
Therefore at creation of a table for example, it can be automatically stored in a schema, and if this is not specified, a default schema can be automatically assigned.
In HOPEX there is not a schema concept, but a specific concept - the Qualifier - which enables prefix of database object names at generation. If for example you want objects to have names prefixed "MEGA", you must enter this value in the Qualifier field of the objects in question.
Inheritance
The Qualifier property can be defined at database level and on all other object types. There is an Inheritance system: if the Qualifier is not specified at the level of a table, by default it is the value entered on the database that is taken into account.
To prefix the name of an object at generation:
1. Open the properties dialog box of the object in question.
2. Click the drop-down list then Options > Generation.
3. In the Qualifier field, enter the value that will prefix the name of the object.
DBMSs concerned
The Qualifier is available for the following DBMSs:
• Oracle
• SQL Server
• DB2
• MySQL