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)
Posted: 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)
|
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)
|
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 |