- This topic has 5 replies, 3 voices, and was last updated 15 years, 8 months ago by
.
-
Posts
-
Hi guys,
How do I create a new schema in Derby from the Database Explorer view? I am used to Oracle and Toad so this is new to me. Any body know a quick answer? I am in the Database Explorer view. I would like to create a new shema and add some tables to it.
Thanks.
You can refer to this quickstart doc:-
http://www.myeclipseide.com/documentation/quickstarts/dbexplorer/@support-nipun wrote:
You can refer to this quickstart doc:-
http://www.myeclipseide.com/documentation/quickstarts/dbexplorer/The quickstart doesn’t answer this question. I would also like to know the answer. Also, what are the passwords for the current schemas?
You can add the schema name before your table names when you run a query and the schema will be created e.g. If you want to create a table called “xyz” under a new schema called “NewSchema”, you can run your create statements like this:-
Create NewSchema.xyz ( … ).
