11.1 Base table operations

This section explains base table operations.

For details about operations on multi-chunk tables of base tables, see 11.4 Performing operations on multi-chunk tables.

Organization of this section

• 11.1.1 Defining a base table

• 11.1.2 Adding a column to a base table

• 11.1.3 Changing the column name of a base table

• 11.1.4 Retrieving and updating data in a base table

• 11.1.5 Deleting all rows from a base table

• 11.1.6 Changing a single-chunk table to a multi-chunk table

• 11.1.7 Storing data in a base table (data import)

• 11.1.8 Outputting data from a base table to a file (data export)

• 11.1.9 Checking whether a single-chunk table needs to be reorganized

• 11.1.10 Reorganizing a single-chunk table

• 11.1.11 Changing a row store table to a column store table

• 11.1.12 Changing a column store table to a row store table

• 11.1.13 Checking the definition information for a base table (searching a dictionary table)

• 11.1.14 Changing the data DB area that stores a base table

• 11.1.15 Deleting base tables

To Page Top