ALTER TABLE COLUMN CACHE | NOCACHE

ALTER TABLE ALTER COLUMN CACHE | NOCACHE changes the cache setting for a symbol column.

Syntax#

Flow chart showing the syntax of the ALTER TABLE keyword Flow chart showing the syntax of NOCACHE | CACHE

  • columnName is the symbol data type.
  • By default, a symbol column is cached.
  • Refer to the Guide on symbol for the advantages of caching symbols.

Examples#

ALTER TABLE 'taxi_ride' ALTER COLUMN passenger_count NOCACHE;