Re: isql: How to Make List of Tables & Total Rows?
In article <Cn6xKo.KLx@eskimo.com> gshep@eskimo.com (Greg Sheppard) writes:
> 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>
update statistics;
select tabname, nrows from systables;
--
Usenet is like Tetris for people who still remember how to read.
-Joshua Heller.
Clay Irving (clay@panix.com)