Use the USE IN command:

alter table myTable rename column col1 to col2
use in select("myTable")

sele * from table1, table2 into table table3 ....
use in select("table1")
use in select("table2")

Einar

>AFter using Alter Table such as
> alter Table myTable rename Column Col1 to Col2
>I notice that if try to use the table
> use myTable
>I can get an error message such as
> myTable is already open
>
>The same can happen after using a select statment such as
> Sele * from table1, table2 into table table3 ....
>
>Is there a way other than close data and/or close all to deal with this
>problem?
>
>Thanks
>Steve Elster