ALTER TABLE Syntax (Storage Conversion) | VantageCloud Lake - ALTER TABLE Syntax (Storage Conversion Form) - Teradata Vantage

ALTER TABLE [ database_name. | user_name. ] table_name,
  STORAGE = TD_OFSSTORAGE
  [ ORDER BY column [,...]]
  [ PARTITION BY COLUMN | NOT PARTITIONED ] [;]

Syntax Elements

database_name

[Optional] Containing database.

Default: database for current session

user_name

[Optional] Containing user name.

Default: database for current user

table_name

Name of Block File System table to convert to Object File System table.

Table requirements:

• Must be empty.
• Cannot be a load-isolated, temporal, queue, volatile, global temporary, or foreign table.
• Cannot contain a join index.
• Cannot contain a referential integrity constraint maintained by Vantage.

ALTER TABLE ignores table has options the Object File System does not support and issues a warning.

STORAGE = TD_OFSSTORAGE

Specifies that converted table is stored in the Object File System.

ORDER BY column [,...]

[Optional] ORDER BY clause for converted table.

PARTITION BY COLUMN

[Optional] By default, ALTER TABLE creates the Object File System table in Parquet format, which is partitioned by column, but you can include PARTITION BY COLUMN for documentation.

NOT PARTITIONED

[Optional] Use if you want the Object File System table to be in row format.