Database Schema

[cVz]

what exactly is a 'Database Schema' ?? and how can i make one ??

[Ramy Mahrous]

Database scheme contains all create scripts for objects, that's allow you to create the same structure of the database you run this scheme on.
Sample database scheme:

Use Master
Go
Create Database CVz
Go
Use Cvz
Go
Create Table tbl_Cvz1 (
ID int primary key,
Name nvarchar(Max) not null, /* Max supported in 2005 and later versions of SQL Server*/
Mobile nvarchar(15) null
)

Scheme can't hold objects data, i.e table date..

[sknake]

What are you trying to accomplish? A schema is somewhat an abstract term. For presentation purposes it probably means tables, fields, and relationships. As Ramy mentioned it could also be more comprehensive than that.