Views Wizard (ITB/FBD)

From RapidSQL
Jump to: navigation, search

Go Up to InterBase/Firebird Object Wizards

The Views wizard lets you create a basic InterBase/Firebird view

To create a new view using a wizard:

  1. Open an object creation wizard for a view. For details. see Opening an Object Wizard on page406.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Views (ITB/FBD) - Properties

When creating or editing a view, this tab/panel lets you provide values for the following properties:

Property Description

Name

Provide a name for the view.

Check Option

When enabled, a WITH CHECK OPTION argument is included with the DDL generated to create the view. This prevents INSERT or UPDATE operations on an updatable view if that operation violates the search condition specified in the associated WHERE clause.

When editing a view, these values cannot be modified.

Views (ITB/FBD) - Definition

When creating or editing a view, this tab/panel previews the DDL reflecting your property values and lets you provide or edit the relevant query.

Personal tools