Example - Advanced SQL Engine - Teradata Database

SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
ynt1557098768177.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1103
lifecycle
previous
Product Category
Teradata Vantageā„¢

The following example returns the list of objects excluded from customer data space computations on a system. An asterisk (*) means all tables of the database.

EXEC systemfe.CDS_ViewExclusions;
DataBaseName    TableName
DBC             *
dbcmngr         *
LockLogShredder *
PDCRADMIN       *
PDCRDATA        *
PDCRSTG         *
SQLJ            *
SysAdmin        *
SYSBAR          *
SYSJDBC         *
SYSLIB          *
SYSSPATIAL      *
SYSTEMFE        *
SYSUDTLIB       *
Sys_Calendar    *
TDMaps          *
TDQCD           *
TDStats         *
tdwm            *
TD_SERVER_DB    *
TD_SYSFNLIB     *
TD_SYSXML       *