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: 167

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

Related posts about sql-server

Related posts about Oracle