>>Hi
>>I am trying to delete a column - the 'drop' command does not seem to work
>>does anyone know the proper sytax?
>>

>>Alter Table C:\mytable.dbf drop Column 'notneeded'
>>

>You don't need quotes around the column name:
>

>CREATE TABLE dropcoltest ( Col1 C( 1 ), Col2 C( 1 ) )
>CLOSE DATABASES all
>ALTER table dropcoltest drop COLUMN col2
>MODIFY STRUCTURE
>

thanks Al. exactly what i was looking. worked like a charm.

k