Populate tables list

Previous Next

In Delivery Manager, in "Application Tables", creates or updates a list of database tables and interface tables defined for "Application" as defined in "Database account".

The purpose of this list is that you can specify :

which of these application tables are deliverable,

which must be skipped in create-tables scripts, and

for which an ALTER TABLE statement must be generated for it in the create-tables script, as opposed to the default CREATE TABLE statement (the Upgrade Hint setting).

If you re-run "Populate tables list", any previous Deliverable, Skipped, and Upgrade Hint settings remain unaffected.

In the case of the USAUTH application, a first-time suggestion for deliverable tables is made by USoft.

To read the table names, the application is automatically opened from Repository, except when Application = USERVICE (the Service Definer application delivered by USoft), in which case the application is automatically opened from Flat Files.

Parameters

Name

Type

Optional?

Application

Application

No

Database account

Database account

No

Notes

The "Populate tables list" action lists database tables and interface tables, but not Logical Views and Component Tables.

Because the "Populate tables list" action does not list tables with Interface = No that are defined in modules, you cannot use the list to deliver appdata from non-interface tables in modules. For more on this, go to the " Delivering modules " help topic.