>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
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up