Generating Tables

When you have stored all table, column, domain, relationship, and constraint definitions in the repository, you can have USoft generate the corresponding database tables, complete with dabase indexes.

Best practice is to re-generate a table immediately each time you have entered or changed the definitions. Otherwise you might end up with an application in which the table definitions and user interface are not synchronized.

If your company or organization uses more than one RDBMS, you need to specify the RDBMS, at which the generated commands should be targeted, before you actually start creating or replacing tables. Also, there may be occasions on which you want to create application tables under a different account than the one you are currently logged on to.

The table generator enables you to create or replace the physical tables, indexes, and sequences as defined conceptually in the repository. You can either do this online, or you can have the necessary commands written into script files which you can execute later (e.g. to set up the production database).

At some point, your database may contain tables for which there are no (longer) definitions in your repository. This is the case, for example, when you have deleted records from the Tables table, or when USoft Developer has renamed tables to OLD_<table_name>. Similarly, when you use Oracle, there may be sequences (i.e. sequence numbers) that are no longer used. To save disk space and to increase performance, you are advised to remove (drop) them from your database.

NOTE: If you find it necessary to make changes to the data model, it is advisable to run Violation Reports from USoft Benchmark.