Archives of the TeradataForum

Message Posted: Mon, 26 Apr 2004 @ 19:42:58 GMT

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

Try this DBC table select:

     SELECT
     T.DATABASENAME
     ,T.TABLENAME
     ,T.CREATORNAME
     ,T.TABLEKIND
     ,T.LASTALTERNAME
     ,T.CREATETIMESTAMP
     ,T.LASTALTERTIMESTAMP
     ,T.REQUESTTEXT
     FROM
             DBC.TABLES T
     WHERE
             T.DATABASENAME IN ('CSRM_DEPT_DB','CSRM_TEMP_DB','CSRM_TEST_DB','RMUS_APPL_DB','CALL_DEPT_VMDB')
     AND     T.REQUESTTEXT LIKE '%PUTTABLEORVIEWNAMEHERE%'
     ORDER BY
             T.DATABASENAME
             ,T.TABLENAME
             ,T.CREATORNAME
             ,T.CREATETIMESTAMP
             ,T.LASTALTERTIMESTAMP;

-- Ed

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