TABLE_TYPE=

Specifies the type of table storage FedSQL will use when creating tables in SAP HANA.

Valid in: CREATE TABLE statement
Category: Data Access
Interactions: GLOBAL and GLOBAL TEMPORARY have the same behavior
LOCAL and LOCAL TEMPORARY have the same behavior
Data source: SAP HANA

Syntax

TABLE_TYPE= [COLUMN] [GLOBAL] [GLOBAL TEMPORARY] [LOCAL]
[LOCAL TEMPORARY] [ROW]

Arguments

COLUMN

creates a table using column-based storage in SAP HANA.

GLOBAL | GLOBAL TEMPORARY

creates a global, temporary table in SAP HANA. The tables are globally available; however, the data is visible only in the current session.

LOCAL | LOCAL TEMPORARY

creates a local, temporary table in SAP HANA. The table definition and data are visible only in the current session.

ROW

creates a table using row-based storage in SAP HANA.

Details

The SAP HANA TABLE_TYPE= option is available as a connection option and as a table option. If neither are specified, tables that are created in SAP HANA follow the SAP HANA default for row or column store.

See Also

Last updated: February 23, 2017