Archives of the TeradataForum
Message Posted: Tue, 07 May 2002 @ 18:25:26 GMT
As most people have mentioned you can generate SQL statements from the DBC dictionary to get the information. For very large systems there is the issue that the count(*)'s will take quite a long while.
If you collect statistics on the tables then a quicker method to do this would be to run help statistics dbname.tablename (again you can generate this via SQL) it also gives you the date the stats were collected.
Another easy option if you only want a small set of tables (or in one database) is to use WinDDI where if you highlight with the cursor the tables you want, right click and then you ca run a row count or statistics report for all the highlighted tables
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|