CMSMALLFILE

Contains the physical bytes that makes up a particular managed file. This table contains only the contents of those files that are less then or equal to 32K and have a storage type of 0 in the CMFILE table.

Column Descriptions:

NameTypeDescription
CMFILE_IDBIGINT NOT NULLThe numeric identifier of the managed file.
CONTENT_WORKSPACECHAR (25)The current workspace with which the file contents is associated.
CMFILEBLOB (32000)The physical bytes of the managed file.
CONTENT_OLD_WKSPCHAR (25)The previous workspace with which the file contents was associated.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
I0000428CMFILE_ID+CONTENT_WORKSPACEUnique Index