Previous Topic: The Materialized Query Table EditorNext Topic: Specify the Source Tables for a Materialized Query Table


Define the Properties of a Materialized Query Table

You use the Materialized Query Tables editor to add and change the properties of a materialized query table.

To define the properties of a materialized query table

  1. Right-click a Materialized Query Table in the Model Explorer and select Properties from the drop-down menu.

    The Materialized Query Table editor opens.

  2. Work with the following options:
    Name

    Specifies the materialized query table name.

    Schema

    Specifies the default schema for the materialized query table.

    Generate

    Generates a CREATE MATERIALIZED QUERY TABLE statement for this materialized query table in the schema generation script when this check box is selected.

  3. Click the From tab and select the tables or views you want to include in the materialized query table. Move the tables from the Available Tables and Views: list to the From: list. This action populates the Select tab.
  4. Click the Select tab and specify the columns to include in the materialized query table. Move the columns from the Available Tables and Views: list to the Columns: list.
  5. In the Select tab, you can create a materialized query column reference to any table column in your model. Work with the following options:
    Alias

    Edit the alias of the selected materialized query column.

    New (Expression)

    Opens the New Materialized Query Table Column dialog where you can enter a user-defined expression as a materialized query column.

    Select Type:

    Select an expression type from the drop-down list: All or Distinct.

  6. Work with other options in the editor, then click Close.

    Your changes are saved and the dialog closes.

    Note: Click Cancel to close the dialog without saving your changes.

More information:

Materialized Query Tables

Specify the Materialized Query Columns

Specify the Source Tables for a Materialized Query Table

Specify Search Conditions for Generating the SQL Code for a Materialized Query Table

Specify General Physical Properties for a Materialized Query Table

Create User-Defined SQL Code for a Materialized Query Table