Deletes a large object (LOB) stored in memory and invalidates its LOB locator.
deallocate locator locator_descriptor
is a valid representation of a LOB locator: a host variable, a local variable, or the literal binary value of a locator.
Deallocates the LOB referenced by @v:
deallocate locator @v
Use deallocate locator within a transaction. Adaptive Server automatically deallocates each locator at the end of a transaction.
deallocate locator can conserve memory. When many LOB locators are created within a transaction, use deallocate locator to remove individual LOBs and locators when they are no longer needed.
Any user can execute deallocate locator.
Transact-SQL functions: locator_literal, locator_valid, return_lob, create_locator
