Teradata Tidbits

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';