Large-Object Data Types

Large-object data types can store extremely large column values, such as images and documents, independently of the column.
Large-Object Data Type
Read syntax diagramSkip visual syntax diagramTEXTBYTEINTABLEblobspaceBLOBCLOB
Element Description Restrictions Syntax
blobspace Name of an existing blobspace Must exist Identifier
The large object data types can be classified in two categories:
  • Simple large objects: TEXT and BYTE
  • Smart large objects: CLOB and BLOB