#DateForumTypeThreadPost
106 Jul 2012 @ 01:25 PDTAnalyticsReplyTo find record counts for all tables in a particular database This should do it: SELECT 'SELECT '''||TRIM(TABLENAME)||''' AS TABLE_NM, SUM(1) AS ROW_CNT FROM '||TRIM(DATABASENAME)||'.'||TRIM(TABLENAME)||' GROU...