File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Schema Name and Database Name Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Schema Name and Database Name" Watch "Schema Name and Database Name" New topic

Schema Name and Database Name

JiaPei Jen
Ranch Hand

Joined: Nov 19, 2000
Posts: 1309
I asked my supervisor the database name. He told me the schema name is "xxxx". Is schema name equivalent to the database name?
Julian Kennedy
Ranch Hand

Joined: Aug 02, 2004
Posts: 823
No. In a physical sense the word schema tends to mean a set of database objects (tables, etc.) owned by a specific user. A database may have several schemas.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33102

You didn't ask about this, but there are also nodes. A node may have several databases.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Schema Name and Database Name
It's not a secret anymore!