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


Reply via email to