In-Row Off-Row LOB

Adaptive Server 15.7 supports the storage of in-row LOB columns for text, image, and unitext datatypes when they are small, and subject to available space in the page.

When a LOB expands in size or its space is used for other in-row columns (such as those used for varchar and varbinary datatypes), Adaptive Server seamlessly migrates the in-row LOB data to off-row storage, automatically replacing the data with an in-row text pointer.

In Adaptive Server 15.7, you can use:

See "In-Row, Off-Row LOB" in the Transact-SQL Users Guide.