db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: Questions about ij> connect
Date Tue, 26 Jun 2007 16:53:29 GMT
> How do I create a schema?

http://db.apache.org/derby/docs/10.2/ref/rrefsqlj31580.html
describes the CREATE SCHEMA statement.

> It seems like I should create a schema before I create any databases, 

No, it's the other way around. Each database can have one or more
schema. So create the database first, then connect to it and
create the schema within it.

> Once I've created a schema, how do I specify it for the 
> connect ...;create=true command, or how do I set it for subsequent commands 
> while using ij?

There is a SET SCHEMA statement you can use:
http://db.apache.org/derby/docs/10.2/ref/rrefsqlj32268.html

thanks,

bryan



Mime
View raw message