Quite simply, ALTER TABLE was introduced in Visual FoxPro, and is not available in FoxPro.
For a workaround, use COPY STRUCTURE EXTENDED, modify the array, and the do a CREATE FROM (array).
>*** No chance for upgrade at this time ***
>Hello all.
>
>I'm getting an "unrecognized command verb" when trying to alter a table in 2.6. Here's my code:
>
>select allgqtmp
>alter table allgqtmp add column id c(9)
>
>What am I doing wrong???
>
>Thanks,
>Sunshine
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
