meta_DatabaseBusEntities - 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

meta_DatabaseBusEntities

Returns the Business Entities defined for the current databases in systems being tracked by MDS. Corresponds to the relationship DatabaseHasEntities.

 

Table 84: Columns, Data Types, and Values of the meta_DatabaseBusEntities View  

Column

Data Type

Values

SystemName

VARCHAR(256)

 

DatabaseName

VARCHAR(128)

 

EntityName

VARCHAR(128)

 

EntityType

VARCHAR(6)

  • ET_DE = Dependent
  • ET_DR = Derived
  • ET_IE = Independent
  • DatabaseLoid

    INTEGER

     

    EntityLoid

    INTEGER