Query Tab, Properties Window (View Designer)

      Tasks

Contains options for controlling the behavior of the view you are building or modifying.

Options

View name

Displays the name for the current query. If you have not yet saved your view, the default name is displayed. You cannot change the name in this box. To assign a name, use the Save or Save As commands from the File menu.

Output all columns

Specifies that all columns from all tables currently displayed will be in the view. Choosing this option is equivalent to specifying an asterisk (*) in place of individual column names.

DISTINCT values

Specifies that the query will filter out duplicates in the view. This option is useful when you are using only some of the columns from a table and those columns might contain duplicate values, or when the process of joining two or more tables produces duplicate rows in the result set. Choosing this option is equivalent to inserting the word DISTINCT into the statement in the SQL pane.

Encrypt view

(Microsoft SQL Server only.) Encrypts the view when you save it. You will continue to be able to work with the view until you close the View Designer.

Important   After you close an encrypted view, you will no longer be able to open it in the View Designer.

GROUP BY extension

(Microsoft SQL Server only.) Specifies that additional options for views based on aggregate queries are available.

WITH CUBE

(Microsoft SQL Server only.) Specifies that the aggregate query should produce summary values for groups specified in the GROUP BY clause. The groups are created by cross-referencing columns included in the GROUP BY clause, and then applying the query's aggregate function to produce summary values for the additional super-aggregate rows. The With CUBE option is multi-dimensional, creating summaries from all combinations of aggregate functions and columns in the query.

WITH ROLLUP

(Microsoft SQL Server only.) Specifies that the aggregate query should produce summary values for the groups specified in the GROUP BY clause. The With ROLLUP option is similar to the With CUBE option, but creates only one type of summary for each combination of column and aggregate function.

ALL

(Microsoft SQL Server only.) Specifies that the aggregate query will include any duplicate rows in the summary.