How to Get Table Size in Sybase IQ



Share this article :

Execute below command to get the table size in Sybase IQ.

sp_iqtablesize ( table_owner.table_name )

##Example##

sp_iqtablesize ('ITSITI.ARADAEM')
Column nameDescription
Ownername Name of owner.
Tablename Name of table.
Columns Number of columns in the table.
KBytes Physical table size in KB.
Pages Number of IQ pages needed to hold the table in memory.
CompressedPages Number of IQ pages that are compressed when the table is compressed (on disk)
NBlocks Number of IQ blocks.

Reference

Sybase InfoCenter

Related posts

How to Find Database Space Information on Sybase IQ
How to Change A User Password in Sybase IQ
How to Drop Data File in Sybase IQ
How to Increase/Extend Data File(s) Size in Sybase IQ
© 2018 ITsiti. All Rights Reserved
Powered by KEEM