This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Schema Name and Database Name" Watch "Schema Name and Database Name" New topic
Author

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.

Jules
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 30050
    
149

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
 
subject: Schema Name and Database Name
 
Similar Threads
"hibernate.hbm2ddl.auto">create - to generate DB Tables
To all beta testers
servlets and xml
Roles in IT suitable for "Visual thinkers" ?
Do all methods have to be concrete?