I want to know that as we create schema in oracle and we store our database in that schema, in a similar way can we create schema in SQL server so that we can create and store our database in that schema.
2007-02-15 17:14:41 · 2 answers · asked by SwetangC 1 in Computers & Internet ➔ Programming & Design
The Database in Oracle contains the physical files required to contain the objects. The instance contains the memory structures and background processes.
The schema is a grouping of objects owned by a user. The schema cannot be created until the database exists as there would be no where to store the user's objects. There can be multiple schemas in a database. The schema is stored in the database, not the other way around
2007-02-16 02:14:28 · answer #1 · answered by Elizabeth Howard 6 · 0⤊ 0⤋
no, it's not really the same thing in sql server. a "schema" is created when a user is created in sql server. it's not really the same thing, it's more about ownership in sql server. when you create a user in sql server you can then create objects as that user and they will be owned by that user. you then access them by referencing the owner (i.e. select * from dbo.employee)
2007-02-18 20:17:25 · answer #2 · answered by ecofer 2 · 0⤊ 0⤋