>Mo,
>
>
>How long is the Script? Maybe it exceeds 8192 characters, that is the maximum length of a command in foxpro. Did you try to create the table in parts, like:
>
>

>create table mytest (PK I autoinc not null) && Now you add the fields one by one
>
>alter table mytest add column newColumn C(50)
>alter table mytest add column someFK I
>
>* etc, taking into account all the options for those commands
>

I tried the Alter table xxx add column but it failed.

The script run fine and the table get created but it fails (I get the error) after I close and re-open the project.