RE: number of rows

Posted in 2003

Colin Bull — Tue, 11 Nov 2003 08:27:14 -0000 — source: Usenet: comp.databases.informix

Jorge Valenzuela wrote > > Can anybody tell me how can I know how many rows, indexes and > fields there > are in every table on my database ? how about select t.tabname, count(*) ,max(nrows) nrow, max(ncols) ncol from systables t, sysindexes i where t.tabid= i.tabid group by 1 Colin Bull c.bull@videonetworks.com sending to informix-list