Use the CREATE TABLE statement to define base tables. This SQL statement specifies a table name, one or more column names, and the attributes of each column. The CREATE TABLE statement can also specify data block size, percent free space, and other physical attributes of the table.
The CREATE/MODIFY USER and CREATE/MODIFY DATABASE statements provide options for creating permanent journal tables.
A table stored in persistent storage in the Block File System (which is accessible only on the primary cluster) can use any table-level attributes. A table stored in the Object File System (which can be accessed from the primary cluster or the compute cluster) does not follow the same conventions as a table stored on the Block File System. Object File System tables have default settings for the following attributes, which you cannot change:
- BLOCKCOMPRESSION
- CHECKSUM
- DATABLOCKSIZE
- FREESPACE
- MERGEBLOCKRATIO
The NO FALLBACK attribute is ignored.