17.00 - 17.05 - Example - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SystemFE Macros

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Release Date
June 2020
Content Type
Administration
Publication ID
B035-1103-170K
Language
English (United States)

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       *