2014-08-27

Teradata - Table inventory query

select
       DatabaseName
       , TableName
       , TableKind
from
       dbc.tablesX as T
where
       T.AccessCount is not null
       and T.DatabaseName in (
              ' DATABASE_1_NAME_HERE '
              , 'DATABASE_2_NAME_HERE'
       )

;

No comments:

Post a Comment