Creating synonyms

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

Learn how to create synonyms.

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 > Synonyms.
  4. Click Create synonym.
  5. Select the schema in which you want to define the synonym.
  6. Specify the synonym name.
    Enclose the name in double quotation marks if it contains special characters.
  7. Specify the reference type.
    For example, table, view.
  8. Specify the name of the reference type for which you are creating this synonym.

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

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

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

  9. Click Create to create the synonym.