Table Statistics Summary Table

This table returns one row for each table of each open database on which an UPDATE STATS has been executed.

Table 5. systabstats
Column Name Description
tabrid Rowid primary key value
tabname Name of table.
norows Number of rows in table when last UPDATE STATS was run.
nosampled Number of rows in table that were sampled.
nocols Number of columns in this table.
dbname Name of database (foreign key to sysdbstats table)