what exactly is a 'Database Schema' ?? and how can i make one ??
cVz
19
Junior Poster
Recommended Answers
Jump to PostDatabase 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) …
All 2 Replies
Ramy Mahrous
401
Postaholic
Featured Poster
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
1,622
Senior Poster
Featured Poster
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.