Skip to Content
Former Member
Nov 01, 2013 at 01:05 PM

How to get the record count for all the table in sybase IQ


We need to see what are the tables having huge volume and needs to a backup and clean the existing data.

Since there are veryu huge no of tables we need to get the record counts for all the tables with a single query .

Can any one of them created any stored proc or query to get this ouptu if so please help me also to close this actviity .

Out put table looks like

TName !!Current Table size!! Prev_table_size !!current Record count !!prev record count !!column count !! Index count1!!current Index size!!Prev Index size!!

Please suggest and help at the earliest

Thanks In advance