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