I almost submitted a patch using option 1, like I said I would. I have added a SynonymAliasInfo to hold target of a synonym, which is schemaName.tableName. I think this schemaName needs to be stored as a name, instead of an ID so that the synonym stays valid even after droping and recreating the target schema.
Yes, the namespace for SYNONYM is the same for tables and views. You can't create a synonym if a table of that name already exists. Satheesh Daniel John Debrunner wrote: > >Any explanation of how SYNONYMs are implemented? You had indicated a >couple of days ago you were undecided on how to represent them in system >catalogs. > >Is the namespace for SYNONYM the same as for tables, or separate? If >separate and A.B is both a table name and a synoymn name, which is selected? > >Dan. > > > > >
