Disclaimer: I found this on one of the Sybase utility sites ran by end
users. This was 5 or 6 years ago and I can't
remember which one. I would give credit if I could remember where. Sorry!

Uncomment the commented line if you want to include tables with no entries.

Tom.
----------------------------------------------------------------------------
--------

select o.crdate, o.name, rowcnt(i.doampg) from sysobjects o, sysindexes i
where type = 'U' and o.id = i.id
/* and rowcnt(i.doampg)!= 0 */
order by rowcnt(i.doampg) desc, o.crdate, o.name
go


"Praim Sankar" <psankar@ibc.ca> wrote in message
news:57ad4eb6.0403301259.6849bb5@posting.google.co m...
> I need to find out the size of all tables in a SYBASE database.
> Does anyone have a script that will give me the number of rows and the
> size of the table for each table in a database.
>
> Thanks,
>
> Praim Sankar
> psankar@ibc.ca