RE: Sort the tables in a database by size

Liviu Check out the sysmaster database, tables systabnames, systabinfo and column ti_nptotal. Murray Wood e.g select tabname, ti_nptotal, ti_npused, ti_npdata, ti_nrows from systabnames, systabinfo where dbsname = "my_database" and partnum = ti_partnum order by 3 desc, 1 -----Original Message----- From: Liviu Lintes [SMTP:liviu@garpac.com] Sent: Tuesday, November 23, 1999 6:05 AM To: informix-list@iiug.org Subject: Sort the tables in a database by size Hi, I want to test a 10 MB table. The database has lots of tables. I can find the size of a table running oncheck -pT. But this is not useful when you want to select from hundreds or thousands of tables one which is around 10MB size. So my question is : 1. Does anybody knows a way of sorting the tables in a database by size ? Thanks Liviu