Altering a view

Procedure

  1. Log on to the NonStop SQL/MX Database Manager.
  2. In the navigation tree, navigate to the Schemas folder by expanding Database > My Systems > Catalogs > Schemas.
  3. Expand the Views folder (left pane) or click the Views tab (right pane), and select the view you want to alter.
  4. Right-click and select Alter View.

    The Alter View dialog box appears. If similarity check is disabled in the view, then the Enable Similarity Check option is selected in the Alter View dialog box. And if similarity check is enabled in the view, then the Disable Similarity Check option is selected in the Alter View dialog box.

  5. Click OK.

    Navigate to the Attributes tab of the view, to view the modification for the Similarity Check entry.