By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,117 Members | 1,093 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,117 IT Pros & Developers. It's quick & easy.

Adding Coumn in DataBase

Ali Rizwan
100+
P: 927
Hi
I have a database having columns Stationary, Furniture, Electronics etc.
I want to add a column Others using vb6 how can i do that.
I know to update, adding rows but dont know how to add a column.
Thanxx
Sep 4 '07 #1
Share this Question
Share on Google+
1 Reply


QVeen72
Expert 100+
P: 1,445
Hi,

U can Use Alter Table Statement:

ALTER TABLE MyTable ADD COLUMN Others TEXT(25);


REgards
Veena
Sep 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.