Creating views

Deployment options: Netezza Performance Server for Cloud Pak for Data System Netezza Performance Server for Cloud Pak for Data

Learn how to create views.

Procedure

  1. Log in to the web console and go to Data (Databases).
  2. Select the database in which you want to create a view and click it.
  3. Select DB objects > Views.
  4. Click Create View.
  5. Specify the schema in which you want to define the view.
  6. Specify the name.

    Enclose the name in double quotation marks if it contains special characters.

    The name can be up to 128 characters long and it must begin with a letter or underscore and cannot contain embedded spaces. The name must be unique.
  7. Specify the query.
    Enter the SQL query that provides the columns and rows of this view.

    For Netezza Performance Server for Cloud Pak for Data System 1.0.X, see Creating materialized views.

    For Netezza Performance Server for Cloud Pak for Data System 2.0.X, see Creating materialized views.

    For Netezza Performance Server for Cloud Pak for Data, see Creating materialized views.

    Enclose the database object name in double quotation marks if it contains special characters.
  8. Click Create to create the view.