Archives of the TeradataForum
Message Posted: Fri, 20 May 2011 @ 20:21:44 GMT
Subj: | | Re: Find the number of rows of all tables in a database? |
|
From: | | John_Wight |
Here is a Stored Procedure we use and run once a week. It will post the table row counts for the tables you want to qualify in the CURSOR
definition into a GT table and at the end, post them all to a history table of row counts.
For what it's worth on todays market . . . ;-)
JK
Admin Comment: The attachment can be found at:
www.teradataforum.com/attach.htm
|