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