数据库中的schema是什么

原文：http://www.quackit.com/sql_server/sql_server_2008/tutorial/sql_server_database_schemas.cfm

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.

1. 数据库中的schema用于逻辑上组织对象，比如表、视图、存储过程等。可以将schema比作装对象的容器。

2. 你可以将某个用户的登录权限赋给某个schema，这样该用户只能访问被授权的对象。

3. schema能在数据库中创建和修改，用户能够被赋予访问某个schema的权限。一个shema能够被任何用户拥有，schema的所有权可以转让。