Creating a schema

To create a schema:

Procedure

  1. In the navigation tree, click Database and select a catalog.
  2. In the left pane for a catalog or the Schemas folder within the catalog, right-click and select Create Schema.

    Create Schema dialog appears.

  3. Enter the name of the schema to be created.

    The schema is created within the catalog from where the Create Schema wizard was launched. To create a schema in a different catalog, select a different catalog from the catalog tree in the Create Schema wizard.

  4. Check Set Owner To check box and select a user from the drop down to change the schema owner to a user.
    NOTE:

    Only SUPER user can use this option. If a NON-SUPER user tries to use it, SQL/MX error 1023 is thrown.

  5. Select Let SQL/MX choose the subvolume name to automatically generate a subvolume name, or select a Subvolume Name to manually enter the subvolume name.
  6. Select Repeat Use Allowed to allow NonStop SQL/MX to reuse subvolume names.
  7. Schema gets created even if subvolume name is in use by another schema.

    Click Create to create the schema in selected catalog. Figure 22 shows the Create Schema dialog.

    Create schema

    Table 19 describes the Create Schema wizard buttons.

    Create Schema wizard buttons

    Button

    Function

    Create

    Creates a schema within a catalog.

    Reset

    Resets the selected tab in Create Schema wizard.

    Cancel

    Closes the Create Schema wizard.