Views Editor (IBM DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The Views Editor lets you manage the columns as well as view and modify properties for 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 all columns for the view. Details for each column include the Column Name, the Datatype (and if applicable, with the precision in parentheses), and whether or not Nulls are allowed for that column. You can also set the EnableQueryOptimization property for the view.

Definition

Lets you view and modify the CREATE VIEW DDL that will implement any changes you make in this editor. To modify a view, the existiing view is automatically dropped and then recreated.

Comment

For details on using this tab, see Adding a Comment to an object.

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.