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