Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Adding two or more columns with ALTER TABLE
Message
From
20/04/2001 15:46:48
Jonathan Cochran
Alion Science and Technology
Maryland, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Adding two or more columns with ALTER TABLE
Miscellaneous
Thread ID:
00498095
Message ID:
00498112
Views:
10
Yep, like this:
ALTER TABLE < tablename > ADD COLUMN x C(1) ADD COLUMN y C(2)
The help doesn't mention anything about this (as far as I can tell), and I didn't know this until someone else showed me.

>Hi,
>
>Is it possible to add more than one column using the ALTER TABLE command? I have managed to add just one at a time.
>
>Thanks!
Previous
Reply
Map
View

Click here to load this message in the networking platform