Creating a synonym

Use the Create Synonym window to create a synonym (alternate name) for an existing table, view, or alias at the current server. If you are creating a synonym for an alias, the alias must be for a table or view at the current server.

Authorities and privileges

To create a synonym:

  1. Open the Create Synonym window.
  2. In the Synonym name field, type the unqualified name of the synonym you are creating. The name must not duplicate a table, view, alias, or synonym that already exists and is owned by the authorization ID (Object owner).
  3. In the Object owner field, type the authorization ID of the person who owns the object for which you are creating an synonym.
  4. In the Object name field, type the name of the object for which a synonym is being created.
  5. Click OK.


Related information

Creating an alias