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 |
ViewID |
Teradata assigned identifier for this view |