|
Adding new column to database |
Post Reply 
|
| Author | |
Dean 
Newbie 
Joined: 28-October-2005 Location: United States Status: Offline Points: 0 |
 Post Options
 Thanks(0)
 Quote Reply
 Topic: Adding new column to databasePosted: 10-November-2005 at 6:28pm |
|
For a change that I'm making to my store I need to add a column to one
of the tables in the database. I'm running the MS SQL database
and I've got the SQL Server Enterprise Manager installed. I can
see the database, tables, and columns. I just can't see how you
add a column.
Can anyone point me in the right direction on how you do this? TIA Dean |
|
 |
|
|
cptkoi
Newbie
Joined: 30-October-2005 Location: United Kingdom Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 14-November-2005 at 11:28am |
|
Get enterprise manager to look like the following having selected your database and the table you want to change - click the link and you will be in design mode. BACKUP your database before you make any changes!!!!!!!
Edited by cptkoi - 14-November-2005 at 11:33am |
|
|
"I need a hug, I need love, I need fun, I want to feel happy. Thats the world I want to live in!"
|
|
|
|
|
Dean
Newbie
Joined: 28-October-2005 Location: United States Status: Offline Points: 0 |
Post Options
Thanks(0)
Quote Reply
Posted: 17-November-2005 at 12:27am |
|
Thanks for the reply. I need to do this so that I can limit the
number of items a person can buy with each order.
|
|
|
|
|
Post Reply
|
|
Tweet
|
| Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
Topic Options