2015-03-03

Teradata - How to list all views (with their SQL definition)

select
       *
from
       dbc.tables
where
       1=1
       and tablekind='V'
       and databasename='CFDW2_RDL_ERIDL_CFS_VWS'
;


No comments:

Post a Comment