Database Schema :

A database schema is a way to logically group objects such as tables, views, stored procedures etc.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.


Create Syntax :

CREATE SCHEMA schema_name

Refer :
http://msdn.microsoft.com/en-us/library/ms189462.aspx

http://msdn.microsoft.com/en-us/express/bb403186


http://blog.sqlauthority.com/2009/09/07/sql-server-importance-of-database-schemas-in-sql-server/

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