by We just got Informix 4.1 Online a week ago so this is definitely a
newbie question: How can I make a list of all the tables in a certain
database and each table's total rows? Can I do it with one sql
statement? Would like output like:
table1 <total rows>
table2 <total rows>
etc. Part of the motivation for listing this info is we have a db with
134 tables...I tried to load the tables with some ascii delimited
files...and after an unknown number of successful loads it bombed with
improper number of columns...need to isolate which table is at fault, so
I can then isolate where "I" went astray.
--
+--------------------------------------------------------------------------
| Greg Sheppard "I use a brute force algorithm of cycling: Peddle|
+--------------------------------------------------------------------------