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 |
|
Jamboo
Starting Member
3 Posts |
 Posted - 2008-10-18 : 18:19:53
|
| Is it a simpler way to make tables? I have SQL 2005 and know how to create a simple table via code. I am also wondering what in management studio I can create a table via the interface and object explorer what is that for? |
|
|
malaytech2008
Yak Posting Veteran
95 Posts |
Posted - 2008-10-19 : 01:42:37
|
| U can create table using the code:create table [tablename](column_name1 datatype,column_name2 datatype)In management studio,Database-->Ur Database Name-->Tables--->Rt. click--> New Tablemalay |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-19 : 02:18:05
|
quote:
Originally posted by Jamboo
Is it a simpler way to make tables? I have SQL 2005 and know how to create a simple table via code. I am also wondering what in management studio I can create a table via the interface and object explorer what is that for?
through mgmnt studio you can create tables,constraints,indexes,databases,... using wizards. also you can view objects available in your dbs. In addition to this, you can script out any of objects and even use export,import wizard to transfer data from one db to another. |
|
|
|
|
|
|
mangement studio object explorer what is it?