Select Property Pages

Top  Previous  Next

A View is primarily defined by the Selects it contains.  The Select Property Pages let you specify the various parts of a Select.  It contains tabs for defining the Select Columns and the From, Where, Group By and Having clauses.  A Select Column can be either an expression or a simple reference to another Table or View's Column.  References to other objects are kept up to date if the referenced object changes (i.e. renamed or deleted).

Include Table - When an Available Column is added to create a Select Column, this option is used to determine whether the Column will be prefixed with the name of the Table that owns it.

Include Owner -  - When an Available Column is added to create a Select Column, this option is used to determine whether the Column will be prefixed with the owner of the Table that owns it.

Star Select - select this option if you want to generate "SELECT *".  All of the Available Columns will be added as Select Columns and  ModelRight will keep the Select Columns in sync with the underlying Tables/Views.   However, ModelRight will always generate just "SELECT *" to create the Select statement.