ALTER TABLE COLUMN CACHE | NOCACHE

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

Syntax​

ALTER TABLE tableName ALTER COLUMN columnName { CACHE | NOCACHE };
  • 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 trades ALTER COLUMN side NOCACHE;