Show TOC

Creating SynonymsLocate this document in the navigation structure

Prerequisites

  • You are logged on to the database as a database user.

  • You have privileges for the table.

    More information: SQL Reference Manual, Privileges: Overview

  • The database is in the ONLINE operational state.

Context

A synonym is an alternative name for a database table. Within a database schema, each synonym has a unique name that is different from all other table names. You can use synonyms to shorten a long or complicated table names.

Procedure

  1. In the explorer tree, select the table for which you want to define the synonym.
  2. In the context menu of the table, choose Start of the navigation path New Next navigation step Synonym End of the navigation path.
  3. Enter the name of the synonym.

    More information: SQL Reference Manual, Synonym Name

  4. To make the synonym visible for all database users (public synonym), choose Public.
  5. In the context menu of the editor window, choose Create Synonym.

    The system creates the synonym in the following schema:

    • Private synonym: default schema (usually the schema of the database user who is logged on)

    • Public synonym: PUBLIC schema

Next Steps

SQL Reference Manual, CREATE SYNONYM Statement (create_synonym_statement)