>Using ALTER TABLE I know, but if the table is not in a database how do I check if the column exists before I DROP or ADD it? In a database I would use INDBC() but not sure how to do the same on free tables. Thanks!
>
Hi Renoir,

The TYPE() function can help you

IF TYPE("mytable.myfield") <> "U"
  * Filed exists
ELSE
...
ENDIF