Getting information from sysindexes  Determining how much space a column uses

Chapter 1: System and User-Defined Datatypes

Using readtext and writetext

Before you can use writetext to enter text data or readtext to read it, you must initialize the text column. For details, see readtext and writetext in Reference Manual: Commands.

Using update to replace existing text, unitext, and image data with NULL reclaims all allocated data pages except the first page, which remains available for future use of writetext. To deallocate all storage for the row, use delete to remove the entire row.

There are restrictions for using readtext and writetext on a column defined for unitext. For more information see the “Usage” sections under readtext and writetext in the Reference Manual: Commands.





Copyright © 2005. Sybase Inc. All rights reserved. Determining how much space a column uses

View this book as PDF