Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dbissues
Starting Member
1 Post |
 Posted - 2007-03-16 : 16:37:00
|
| Hello All,My project uses MS SQL server database and is not too big database (have aound 200 table).Now I have to create Database schema for my database as my project needs to be integrated with some other product.I don't know much about database schema and how to start with it. Can someone please give me some inputs on following:1) What exactly database schema should include?2) How should I start creating the schema for my database?3) Are there any tools for doing this?Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-16 : 16:47:24
|
| The database schema is your 200 tables. 1. all user objects2. you can easily script the objects out using Enterprise Manager's generate SQL script wizard3. yes, EMTara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Information - database schema