Changing the Table Category

Changing the Table Category

Prerequisites

Depending on the category of the change, you must note the following features:

Transparent to structure: The table is deleted from the database at activation. Existing data is lost! Any technical settings for the table are also lost.

Structure to transparent: You must maintain certain settings that are necessary for transparent tables (technical settings, table key) since these are not required for structures.

Pooled/cluster to transparent: Since technical settings are meaningless for pooled and cluster tables, you must maintain them before activating the transparent table.

Transparent to pooled/cluster: You must define the assignment to the table pool or table cluster in which the table data should be stored.

Procedure

In the field maintenance screen of the table, choose Extras ® Change table category.

A dialog box appears in which the current table type (transparent database table, structure, pooled table, cluster table) is selected.

Select the table type you require and choose Choose.

You return to the field maintenance screen for the table.

Activate the table with Table ® Activate.

In addition to the above procedure, you can also change the type for pooled tables with the transparent flag.

Changing a pooled/cluster table to a transparent table and vice versa always results in a table conversion (see Adjusting Database Structures).