What is the differnce between an Oracle and Microsoft schema?
Posted
by
Tarzan
on Stack Overflow
See other posts from Stack Overflow
or by Tarzan
Published on 2011-03-19T22:30:37Z
Indexed on
2011/03/20
0:10 UTC
Read the original article
Hit count: 176
I am working on an enterprise project. Some of the team has an Oracle background and some has a Microsoft SQL Server background. There is much confusion when we talk about schemas. I am trying to provide some clarity. Is this an accurate way to describe the difference in the meaning of schemas between the two technologies?
- An Oracle schema is associated with a single user and consists of the objects owned by the user.
- A MS SQL Server schema schema is a namespace.
© Stack Overflow or respective owner