Re: number of rows
update statistics;
select ncols, nrows, nindexes from systables where tabid > 99;
the stats is to ensure that the nrows is correct. The tabid > 99 is to
exclude system tables.
cheers
j.
-.-- --- ..- / -. . . -.. / - --- / --. . - / .- / .-.. .. ..-. . .-.-.- /
... --- / -.. --- / .. .-.-.-
----- Original Message -----
From: "Jorge Valenzuela" <jorgev@uabc.mx>
To: <informix-list@iiug.org>
Sent: Monday, November 10, 2003 9:16 PM
Subject: number of rows
>
> Hi all:
>
> Can anybody tell me how can I know how many rows, indexes and fields there
> are in every table on my database ?
>
> Thanks in advance.
>
>
> hpux 11.0
> ids 7.3
>
>
> sending to informix-list
>
sending to informix-list