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 |
|
peterwilson
Starting Member
15 Posts |
 Posted - 2008-07-07 : 05:00:20
|
| hi friends ,can u tell me how to manage the database or how to create (i means with the help of all Keys , Relationship , and Normalization etc.)table can u give me some kind of example in this ?hop u got my queation.just take any ex. like [Student Reg.]c i m having around 15 table so plz help me on same . |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-07-07 : 05:26:11
|
| Create the table in Management Studio, then script it out, then you will see how it is created. |
 |
|
|
peterwilson
Starting Member
15 Posts |
Posted - 2008-07-07 : 05:34:03
|
| Management Studio ? sorry i m not getting plz clear ur point. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-07 : 05:37:15
|
quote:
Originally posted by peterwilson
Management Studio ? sorry i m not getting plz clear ur point.
I think Rick was referring to sql 2005.You dont have management studio in sql 200. You can use enterprise manager intead:-http://www.plus2net.com/asp-tutorial/sql-newtable.php |
|
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-07-07 : 05:38:29
|
Sorry, yeah, didn't notice it was SQL 2k.. |
|
|
|
peterwilson
Starting Member
15 Posts |
Posted - 2008-07-07 : 06:06:37
|
| ok ya if its enterprise manager thn its ok/>fine this is aslo 1 way to do this ?but how to do this by manually (i mean if u r selecting thr enterprise manager SQl engin get generate the code ) |
|
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-07-07 : 06:24:17
|
| You can either write entire SQL Script by yourself or create entire database schema in EM and generate the script.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
|
|
|
peterwilson
Starting Member
15 Posts |
Posted - 2008-07-07 : 06:32:21
|
| k thnkx fr de great reply.. |
|
|
|
|
|
|
Creating a Table