db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <sathe...@Sourcery.Org>
Subject Re: [PATCH] Synonym support in Derby.
Date Thu, 02 Jun 2005 00:23:28 GMT
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.


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
>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?

View raw message