![]() |
Adding new column to database |
Post Reply ![]() |
Author | |
Dean ![]() Newbie ![]() ![]() Joined: 28-October-2005 Location: United States Status: Offline Points: 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 |
![]() ![]() ![]() ![]() ![]() |
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 |
![]() ![]() ![]() ![]() ![]() |
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 |