ProductCart E-Commerce Solutions Homepage
Forum Home Forum Home > ProductCart > Customizing ProductCart
  New Posts New Posts RSS Feed - Adding new column to database
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Adding new column to database

 Post Reply Post Reply
Author
Message
Dean View Drop Down
Newbie
Newbie
Avatar

Joined: 28-October-2005
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dean Quote  Post ReplyReply Direct Link To This Post Topic: Adding new column to database
    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
Back to Top
cptkoi View Drop Down
Newbie
Newbie
Avatar

Joined: 30-October-2005
Location: United Kingdom
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote cptkoi Quote  Post ReplyReply Direct Link To This Post 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!"
Back to Top
Dean View Drop Down
Newbie
Newbie
Avatar

Joined: 28-October-2005
Location: United States
Status: Offline
Points: 0
Post Options Post Options   Thanks (0) Thanks(0)   Quote Dean Quote  Post ReplyReply Direct Link To This Post 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.  
Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.04
Copyright ©2001-2021 Web Wiz Ltd.

This page was generated in 0.047 seconds.