Skip to end of metadata
Go to start of metadata


Overview

The synonym of the ALTIBASE HDB is almost identical  to Oracle's one except "OR REPLACE" Clause.

Specify "OR REPLACE" clause to re-create the synonym if it already exists in Oracle.

It internally functions to drop and create synonym consecutively.


Example

ORACLE

ALTIBASE HDB

CREATE OR REPLACE PUBLIC SYNONYM offices FOR hr.locations;
DROP PUBLIC SYNONYM offices;

CREATE OR REPLACE [PRIVATE]  SYNONYM offices FOR hr.locations;
DROP [PRIVATE] SYNONYM offices;

CREATE PUBLC SYNONYM offices FOR hr.locations;
DROP PUBLIC SYNONYM offices;

CREATE [PRIVATE] SYNONYM offices FOR hr.locations;
DROP [PRIVATE] SYNONYM offices;

  • No labels