Changing the Table Type

Proceed as follows to change the table type:

  1. In the field maintenance routine of the table choose Extras ® Change table type.

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

  2. Select the table type you require and select Choose.

    3. Note the following for the types of change:

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

    Structure to transparent: You must maintain certain settings which are necessary for transparent tables and which were not required for structures. You must define the technical settings and the table key before activation. Maintain the Tab.Maint.Allowed flag if the standard maintenance routine may access the data of the table.

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

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

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

  3. Activate the table.

The Transparent Flag may not be set in the technical settings when the type of a transparent table is changed. If this flag is set, you must first remove the flag and activate the technical settings before changing the type.

Changing a pooled/cluster table to a transparent table and vice versa always results in a table conversion.