Wednesday, February 1, 2012

Creating Schema

What is Schema ?
A database schema is a way to logically group objects such as tables, views, stored procedures etc. Think of a schema as a container of objects.
You can assign a user login permissions to a single schema so that the user can only access the objects they are authorized to access.
Schemas can be created and altered in a database, and users can be granted access to a schema. A schema can be owned by any user, and schema ownership is transferable.

Create New Schema
Goto Security option of desired database -->Right Click --> New  --> Schema

Now in opened window write your schema name and click OK.
To check your created schema goto Security ---> Schema.

Now its Time to Add schema to the table.For this goto the properties window of desired table, in schema option change the schema. By default schema is dbo.
To see the effect Refresh Tables the view the result.

No comments:

Post a Comment