MID - the modeling company Home Search Tcl Script Help Tcl Script Help Contact Support

Views for ER DB View (ERMDBView)


ProjectModel

OWN ProjectModel of the element.

Package

OWN Package of the DB View

ERMDBView

OWN The ERM DB View itself (if ERM DB View) or the own or assigned ERM DB View (if ERM DBV table, or ERM DBV Column).
ALL All DB views which are used in the from clause of this view.
REFERENCED All DB views which are used in the from clause of this view.
REFRENCES ALL database views using this database view.

ERMAttribute

REFERENCED All ERMAttributes which are referenced in this view.

ERMDBVFrom in DBview.

ALL All database tables of the from clause (sorted).
ER_UNIQUENAME All database tables of the from clause with name or select shortname pattern.
REFERENCES ALL database view from clauses using this database view.

ERMDBVColumn in DBview.

ALL All database tables of the from clause (sorted). Set mode = 1 to restrict the result for columns with not empty AS name.
REFERENCED All referenced database view columns.
REFERENCES All referencing database view columns.

ERMDBTable

ALL All DB tables which are used in the from clause of this view.
REFERENCED All DB tables which are used in the from clause of this view.

ERMViewOpt

ALL All DB view options (sorted).
ALLTRG All DB view options of target system pattern.
TRG DB view option named pattern of target system refentity.
ER_VALID All ER entities that are needed to resolve datatype of foreign key attributes
REFERENCED DB table, DB view, Attributes or View Columns referenced by the WHERE clause.