Using readtext and writetext  Restrictions on text, image, and unitext columns

Chapter 1: System and User-Defined Datatypes

Determining how much space a column uses

sp_spaceused provides information about the space used for text data as index_size:

sp_spaceused blurbs
name            rowtotal  reserved  data    index_size unused 
--------------- --------  --------- ------- ---------- ------ 
blurbs          6         32 KB     2 KB    14 KB      16 KB





Copyright © 2005. Sybase Inc. All rights reserved. Restrictions on text, image, and unitext columns

View this book as PDF