Hi,
I've been searching the web for two days and still cannot find a way to generate DDL code with public synonyms. Would be very grateful for an advice.
Hi,
I've been searching the web for two days and still cannot find a way to generate DDL code with public synonyms. Would be very grateful for an advice.
I think you are dealing with two different and distinct uses of the term "synonym":
1) In logical (entity) modelling, synonyms are alternative business names for an entity, e.g. the entity CUSTOMER may have synonyms PURCHASER and CLIENT.
2) In the physical (database) model, public synonyms are used to remove the need to specify the schema that owns a table. Commonly, the synonym and table name are the same e.g. "CREATE PUBLIC SYNONYM customers for MYSCHEMA.CUSTOMERS;"
It would be very unusual to want public synonyms generated in the database for the business synonyms defined in the logical model.