0 - 1 of 1 tags for all_tables
Table or view that contains the NumberOfRows & NumberOfColumns?

Is there a table or view that contains the NumberOfRows, NumberOfColumns, DataBaseName, TableName?

In Oracle its called all_tables and in Netezza its called _v_table_only_storage_stat.

Here is where I looked:
DBC.ColumnStats
DBC.MultiColumnStats
DBC.IndexStats
DBC.TABLESV

By teradatatester, 22 Aug 2011 | Tagged: statistics dbc numberofrows numberofcolumns columnstats number of rows number of columns table statistics all_tables | 2 comments