11.1.1 Defining a base table
To define a base table, execute the CREATE TABLE definition SQL statement.
For details about the CREATE TABLE statement, see CREATE TABLE (define a table) in the manual HADB SQL Reference.
Note that the specification of STORAGE FORMAT in the CREATE TABLE statement differs depending on whether the base table is to be defined as a row store table or column store table.
-
To define a base table as a row store table
Specify ROW for STORAGE FORMAT in the CREATE TABLE statement. Alternatively, omit the STORAGE FORMAT specification.
-
To define a base table as a column store table
Specify COLUMN for STORAGE FORMAT in the CREATE TABLE statement.
If you define a base table as a multi-chunk table, see also 11.4.1 Defining a multi-chunk table.
- Important
-
-
In HADB, a user (the HADB user with the authorization identifier that was used for the current connection to the HADB server) can define base tables only in a schema which that user owns.
-
Before defining a base table, make sure that you have designed the base table. For details about designing a base table, see 5.2 Designing a table.
-