Views Editor (SQL Server)

From RapidSQL
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Views Editor lets you view columns and change the schema of a view.

To edit a view

  1. Open an editor on the view. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Displays a list of the columns that make up the view. Details include the column Name, its Datatype, and whether the definition allows Nulls. This tab also lets you change the Schema owning the view.

Definition

Lets you view the SQL for the View.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Permissions

For details on using this tab, see Working with Privileges and Permissions.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.