I've also used the technique using an SQL SELECT to add fields to a table - it's simple, and you can even specify the default values in a single step. For example to add Field1 c(10), Field2 n(5,2), Field3 L and Field4 D.

SELECT * , spaces(10) as Field1, ;
 00.00 as Field2, .F. as Field3, ;
 { / / } as Field4 ;
 FROM orgTable ;
 INTO TABLE newTable

Then you just need to make sure both are closed and do some renaming and deleteing of the old table.

Rick

>hi all:
>
>I was wondering if there is a command or some code that I can use to add fields into an existing table.
>
>
>thanks.