db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Fred Janon <fja...@gmail.com>
Subject Re: Is 'SET SCHEMA' a supported IJ command?
Date Tue, 08 Jun 2010 08:10:55 GMT
OK, great, thanks Knut.

Fred

On Tue, Jun 8, 2010 at 15:58, Knut Anders Hatlen <Knut.Hatlen@sun.com>wrote:

> On 06/ 8/10 09:37 AM, Fred Janon wrote:
> > Hi,
> >
> > I was trying to set the 'default' schema in ij to avoid typing the
> > schema name in front of the tables names but could not find any
> > command to do that in the 'derbytools.pdf' file. After searching the
> > mail archive, I saw mention of 'SET SCHEMA XXX'. I tried it and it
> > seems to work but not documented.
> >
> > Is it really a supported command?
>
> Hi Fred,
>
> SET SCHEMA is supported, but it's an SQL statement rather than an IJ
> command, so you'll have to look in the reference manual instead of the
> tools guide. Here's the relevant section:
> http://db.apache.org/derby/docs/10.6/ref/rrefsqlj32268.html
>
> --
> Knut Anders
>
>

Mime
View raw message