BLOBIDM

Part-key identifying the blob.

Yes

INTEGER

4

BLOBID

Part-key identifying the blob.

Yes

INTEGER

4

BlobType

Identifies the type of the blob, such as a file‑based blob.

INTEGER

4

Follow the hyperlink for details.

BlobTag

Identifies the type of content of the blob, such as a policy blob.

INTEGER

4

Follow the hyperlink for details.

Location

The location of the blob data. The format of this string depends on the BlobType.

VARCHAR

255

BlobSize

The real unaltered size of the blob data, independent of factors such as compression and encryption.

DECIMAL

13

The physical blob size (for example, compressed) is stored in the column BLOBPhysicalSize.

VersionIDM

Used to detect and resolve replication update collisions.

INTEGER

4

VersionID

Used to detect and resolve replication update collisions.

INTEGER

4

VersionRanking

Used to detect and resolve replication update collisions.

INTEGER

4

PurgeState

Indicates whether the row can be purged if 'Purge On Replicate' is enabled. This column is ignored on a CMS.

INTEGER

4

Possible values:

0 - Cannot be purged

1 - Can be purged

BLOBPhysicalSize

The physical storage size occupied by the blob. The value depends factors such as the BlobType and whether the blob is compressed.

DECIMAL

13

For file blobs, this represents the disk space used by the blob rather than its actual data size (the file may be compressed).

BLOBState

The current state of the blob.

INTEGER

4

Currently unused.

BLOBAttributes

Attributes of the blob.

VARCHAR

255

Follow the hyperlink for details.