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 ALTER TABLE ALTER COLUMN 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;