View Class Property Descriptions - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

View Class Property Descriptions

 

Table 31: View Class Property Descriptions 

Property Name

Description

CommentString

The comment stored in Teradata for this view

CreatorName

The Teradata user that created the view

DatabaseID

Teradata assigned identifier for the database where this view resides

IsRecursive

Indicates if the view is a recursive view, i.e SELECTs from itself.

Values are Y=Yes, N=No.

This property is set by metaload and DIM Update when they process a view. When an existing database in the DIM is being processed by metaload, it automatically reevaluates any view that has a NULL value for the property.

LastAlterTimeStamp

Time that Teradata last updated the object

ReqText

The SQL string used to create the view

SynchronizationLevel

Internal flag

0 = Invalid references detected
1 = all information complete
-2 = QuickLoaded view

ViewID

Teradata assigned identifier for this view