You can close it with:

USE IN MyTable

Alternately, you can check whether it is already open before you open it:

if not used("MyTable")
  use MyTable...
endif

You might also re-open the table with another alias:

use MyTable again alias MyTable_Purpose

replacing "Purpose" with some relevant description.

The fact that some SQL commands keep tables open can be a hassle; pressumably, VFP does this on purpose, for speed.

>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