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

Database :

Databases are designed to offer an organized mechanism for storing, managing and retrieving information. They do so through the use of tables. If you’re familiar with spreadsheets like Microsoft Excel, you’re probably already accustomed to storing data in tabular form.

Definition : 

A database is a collection of information organized into interrelated tables of data and specifications of data objects.



Syntax :

CREATE DATABASE database_name

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

Creating new Database from Management Studio :

In Object Explorer, connect to an instance of the SQL Server Database Engine and then expand that instance and then Right-click on Databases, and then click New Database.In New Database, enter a database name and click OK.

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