CREATE TABLE with STORAGE Option Syntax | VantageCloud Lake - CREATE TABLE with STORAGE Option Syntax - Teradata Vantage

Default storage can be provided at database or user (profile) level with the DEFAULT STORAGE option. For example:

• DEFAULT STORAGE = TD_OFSSTORAGE

• DEFAULT STORAGE = TD_NDSSTORAGE

TD_OFSSTORAGE is the Object File System storage. TD_NDSSTORAGE is block storage associated with the primary cluster.

See examples 4 and 5 in Examples: CREATE TABLE with STORAGE Option.