16.10 - ActionsV[X] - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Published
April 2018
Language
English (United States)
Last Update
2018-04-26
dita:mapPath
qjg1509413559832.ditamap
dita:ditavalPath
changebar_rev_16_10_exclude_audience_ie.ditaval
dita:id
ujp1472240543947
Database
TDMaps

This view contains the following columns:

View Column Data Type Format Source Table.Column
ZoneName VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionsTbl.ZoneName
Action VARCHAR(24) LATIN

NOT CASESPECIFIC

NOT NULL

X(24) ActionsTbl.Action
Origin CHAR(1) LATIN

NOT CASESPECIFIC

X(1) ActionsTbl.Origin
DatabaseName VARCHAR(128) UNICODE

NOT CASESPECIFIC

NOT NULL

X(128) ActionsTbl.DatabaseName
TableName VARCHAR(128) UNICODE

NOT CASESPECIFIC

NOT NULL

X(128) ActionsTbl.TableName
SourceMap VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionsTbl.SourceMap
DestinationMap VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionsTbl.DestinationMap
CoLocateName VARCHAR(128) UNICODE

NOT CASESPECIFIC

X(128) ActionsTbl.CoLocateName
ActionSQLText VARCHAR(10000) UNICODE

NOT CASESPECIFIC

X(10000) ActionsTbl.ActionSQLText
ActionListName VARCHAR(128) UNICODE

NOT CASESPECIFIC

NOT NULL

X(128) ActionsTbl.ActionListName
GroupOrder DECIMAL(10,2) zz9.99 ActionsTbl.GroupOrder
ActionOrder DECIMAL(10,2) zz9.99 ActionsTbl.ActionOrder
TableSize BIGINT -(19)9 ActionsTbl.TableSize
FractionOfPermDBFree| FLOAT -9.99999999999999E-999 ActionsTbl.FractionOfPermDBFree
UDICnt BIGINT -(19)9 ActionsTbl.UDICnt
QueryCnt BIGINT -(19)9 ActionsTbl.QueryCnt
PKJoinCnt BIGINT -(19)9 ActionsTbl.PKJoinCnt
LastAlterTimeStamp TIMESTAMP(6) WITH TIME ZONE NOT NULL YYYY-MM-DDBHH:MI:SS.S(6)Z ActionsTbl.LastAlterTimeStamp
LastAlterUID BYTE(4)

NOT NULL

X(8) ActionsTbl.LastAlterUID
Issues CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1) ActionsTbl.Issues
ActionsTblDescription VARCHAR(1024) UNICODE

NOT CASESPECIFIC

X(1024) ActionsTbl.ActionsTblDescription