Query Tab, Properties Window (View Designer)
Contains options for controlling the behavior of the view you are building or modifying.
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, choose Save or Save As 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
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. If you need to modify an encrypted view, you must delete it and recreate another.
GROUP BY extension
Specifies that additional options for views based on
WITH CUBE
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 multidimensional, creating summaries from all combinations of aggregate functions and columns in the query.
WITH ROLLUP
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
Specifies that the aggregate query will include any duplicate rows in the summary.
Check Option
Indicates that whenever you open this view and modify the results pane, the DBMS checks that the added or modified data satisfies the WHERE clause of the view definition.
Owner
Shows the name of the view's owner. The owner name is either a SQL Server role or SQL Server user. The drop-down list contains all the users and roles defined in the database. Within the drop-down list, the users and roles have different icons; the role icon shows two faces, the user icon shows only one.
This control is editable only if you are connected to the database as a user that is a member of the db_owner role or is a member of both the db_ddladmin and db_securityadmin roles.
Top
Specifies that the query will include a TOP clause, which returns only the first n rows or first n percentage of rows in the result set. The default is that the query returns the first 10 rows in the result set.
Use this box to specify a different number of rows to return or to specify a percentage.
Percent
Specifies that the query will include a TOP clause, returning only the first n percentage of rows in the result set.
With Ties
Specifies that the view will include a WITH TIES clause. WITH TIES is useful if a view includes an ORDER BY clause and a TOP clause based on percentage. If this option is set, and if the percentage cutoff falls in the middle of a set of rows with identical values in the ORDER BY clause, the view is extended to include all such rows.