Sybase Object Size

To determine object sizes, ordered by decreasing size, in a Sybase database via isql:

select	o.name name,
	sum(convert(int, rowcnt(i.doampg))) rownum,
	sum(convert(int, reserved_pgs(i.id, i.doampg) +
		reserved_pgs(i.id, i.ioampg)) *
		(d.low / 1024)) reserved_kb,
	sum(convert(int, data_pgs(i.id, i.doampg)) * (d.low / 1024)) data_kb,
	sum(convert(int, data_pgs(i.id, i.ioampg)) * (d.low / 1024)) index_kb,
	sum(convert(int, reserved_pgs(i.id, i.doampg) +
			reserved_pgs(i.id, i.ioampg) -
			data_pgs(i.id, i.doampg) - data_pgs(i.id, i.ioampg))
		* (d.low / 1024)) unused_kb
from	sysobjects o, sysindexes i, master.dbo.spt_values d
where	i.id = o.id
	and d.number = 1 and d.type = "E"
group by o.name
order by reserved_kb desc