Example: CDS_ViewExclusions Macro - Analytics Database - Teradata Vantage

SystemFE Macros

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
iqw1628112378327.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
usl1472251351342
lifecycle
latest
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       *