Previous Topic: Define a SQL Server 2008 View Column ExpressionNext Topic: Specify Properties for the WHERE Clause for a SQL Server 2008 View


Select the Tables and Views for a SQL Server 2008 View

Use the From tab in the SQL Server View Editor to select the tables and views that you want to participate in a view. The tables and views that you select in this tab define the list of available tables and views that display in the Select tab that can be selected to participate in a view.

To select the tables and views to participate in a view

  1. Click Views on the Model menu.

    The SQL Server View Editor opens.

  2. Select the view in the Navigation Grid for which you want to select tables and views.
  3. Click the From tab and work with the following options:
    Available Tables and Views

    Displays the tables and views in the current model that are available to use in the view. Select a table or view that you want to add and click the right arrow button after each selection to add it to the From list box.

    From

    Shows the tables and views that you selected from the Available Tables and Views list box.

    Alias

    Lets you enter an alternative name for the selected source in the From list box. An alias is typically a new name that is more appropriate in the context of the table or view selected. The Alias option becomes available only after you have selected a source in the From list box.

  4. Click Close.

    The tables and views you selected are included in the selected view and the SQL Server View Editor closes.