Thursday, May 26, 2011

What is Schema in SQL Server 2005/2008

It is a logical container of objects. A schema can have all types of objects and it can have objects owned by different owners. A set of objects can be grouped as a schema.

The default schema is ‘dbo’, any object created without specifying particular schema comes under dbo schema.

Users can be restricted to access only to objects belongs to a schema.

No comments:

Post a Comment