Teradata Tidbits
Jump to navigation
Jump to search
Record Count for all Tables in a Database
select 'select count (1), ''' || trim(tablename) || ''' (varchar(30)) from ' || trim(databasename) || '.' || trim (tablename) || ' union ' from dbc.tables where databasename = 'my_database';