• Product Information
  • About
  • Product tour
  • News
  • Screenshots
  • Testimonials
• Support Information
  • Documentation
  • FAQ
  • Support
  • Upgrade policy
• Download
• Purchase

Download Buy

MS SQL Maestro online Help

Editing view properties

View Editor provides you with an ability to edit view properties. The Properties tab allows you to change the view name, view definition, the view owner and the comment for the view.

Subitems

Every tab is intended for managing some view subitems (e.g. fields, indexes, triggers, and CLR triggers). Each object can be opened in its editor. Use grid’s popup menu to create new, edit or drop the selected view subitems. Using the popup menu you can also copy the selected objects to clipboard or paste previously copied objects.
You can operate on several objects at a time. For this you have to select view objects with the Shift or the Ctrl key pressed. After a group of objects is selected you can operate on it, e.g. delete several objects at once, as if it were a single object.

See also: Fields, Indexes , Triggers, and CLR Triggers

Body

You can edit the view definition in this box.

Use the Name field to specify the view name.

Note: the name of the object must be unique among all the object names in its container. Moreover, all the objects that are source of data need unique names among themselves. You can use any identifier that is allowed by Microsoft SQL server.

Owner

Represents the view owner. By default, only the owner of an object can perform various operations with the object. In order to allow other users to operate it, privileges must be granted. (However, users that have the superuser attribute can always access any object.)

Comment

This field stores a comment to the view.

Create Date

Displays the date when the view was created.

Modify Date

Displays the date when the view was last modified.

Encrypted

If checked, the view is prevented from being published as part of SQL Server replication.

Schema Binding

Binds the view to the schema of the underlying table or tables. If checked, the base table or tables cannot be modified in a way that would affect the view definition. All referenced objects must be in the same database.

With Check Option

Forces all data modification statements executed against the view to follow the criteria set within select statement. When a row is modified through a view, the With Check option ensures that the data remains visible through the view after the modification is committed.

View Meta Data

Specifies that the instance of SQL Server will return to the DB-Library, ODBC, and OLE DB APIs the metadata information about the view, instead of the base table or tables when browse-mode metadata is being requested for a query that references the view. If checked, the browse-mode metadata returns the view name and not the base table names when it describes columns from the view in the result set.

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.