You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Fred Janon <fj...@gmail.com> on 2010/06/08 09:37:28 UTC

Is 'SET SCHEMA' a supported IJ command?

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?

Thanks

Fred

Re: Is 'SET SCHEMA' a supported IJ command?

Posted by Fred Janon <fj...@gmail.com>.

OK, great, thanks Knut.

Fred

On Tue, Jun 8, 2010 at 15:58, Knut Anders Hatlen <Kn...@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
>
>

Re: Is 'SET SCHEMA' a supported IJ command?

Posted by Knut Anders Hatlen <Kn...@Sun.COM>.

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