Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
DavidNR: "MS SQL Maestro is a great app. Loved it. I only used it for its blob support thus far, very nice and very fast".
Alex Torin: "Several months ago I downloaded the trial versions of several Microsoft SQL administration tools that I was able to find using google. I had considerable trouble with most of them crashing... but using your product I was able to isolate and solve the problems I was having. I decided to add it to my toolkit and have recommended it to a few others".

More

Add your opinion

MS SQL Maestro online Help

Prev Return to chapter overview Next

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.



Prev Return to chapter overview Next