# | Date | Forum | Type | Thread | Post |
---|---|---|---|---|---|
1 | 06 Jul 2012 @ 01:25 PDT | Analytics | Reply | To 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... |