Find the number of rows in a table from metadata I want to write a single select statement to determine the number of rows in a set of tables in Sybase IQ.

In SAS, I write this as 

CREATE TABLE dsnobs as
SELECT libname,memname,nlobs, datetime() format DATETIME16. as timestamp
FROM dictionary.tables 
WHERE (libname=upcase('MY_LIB') &amp; memname IN ('TABLE_1', 'TABLE_2', 'TABLE_3'));


For your information,


a SAS libname is something like a table creator or table space
the dictionary are similar to IQ SYS tables
memname is just the name of the table


Can I do the same thing in IQ?

An approximate solution, or an indication on the space used would suit me too.
For SybaseIQ 16 (SAP IQ 16.0 SP08) use system viewSYSTAB as:

select * from SYSTAB


Here is a link to SyBase IQ v16 documentation. Page 918 (correction to my comment above) says:


  Each row of the SYSTAB system view describes one table or view in the
  database. Additional information for views  can be found in the
  SYSVIEW system view. The underlying system table for this view is
  ISYSTAB.
  
  Column:      count     Datatype:    UNSIGNED BIGINT     Description:
  The number of rows in the table or mate­ rialized view. This value is
  updated dur­ing each successful checkpoint. This number is used to
  optimize database ac­cess. The count is always 0 for a
  non-materialized view or remote table.