You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by Rick Hillegas <Ri...@Sun.COM> on 2009/08/24 14:57:21 UTC

Re: Synonym To Table In Different Derby Database?

Hi Chris,

You can use a table function to access a table in another database (the 
other database could be Derby, MySQL,  Postgres, etc.). For more 
information on table functions, please see the Developer's Guide ( 
http://db.apache.org/derby/docs/10.5/devguide/devguide-single.html#cdevspecialtabfuncs 
) and the white paper here: 
http://developers.sun.com/javadb/reference/whitepapers/index.jsp

Hope this helps,
-Rick

cmoody12 wrote:
> I would like to know if, in one Derby database, I can create a synonym to a
> table that is in another Derby database.  If so, please tell me what that
> syntax is.  Thanks in advance for any information you can provide!
>