Archives of the TeradataForum

Message Posted: Wed, 14 Dec 2011 @ 15:35:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

This how I do that:

     SEL TRIM(DATABASENAME) || '.' || TRIM(TABLENAME)  (TITLE'') FROM
     SYSDBA.REFRESH_TABLE_LIST A WHERE NOT EXISTS

     ( SEL DATABASENAME, TABLENAME
          FROM
             (SEL DATABASENAME,
                     TABLENAME
             FROM DBC.COLUMNSTATS
             WHERE FIELDSTATISTICS IS NOT NULL
             GROUP BY 1,2

                     UNION

             SEL DATABASENAME,
                       TABLENAME
              FROM DBC.MULTICOLUMNSTATS
             WHERE COLUMNSSTATISTICS IS NOT NULL
              GROUP BY 1,2

                    UNION

             SEL DATABASENAME,
                           TABLENAME
             FROM DBC.INDEXSTATS
             WHERE INDEXSTATISTICS IS NOT NULL
             GROUP BY 1,2) B
          WHERE A.DATABASENAME = B.DATABASENAME
            AND A.TABLENAME    = B.TABLENAME);

	<Prev	Next>		<<First	<Prev	Next>	Last>>