CLOSING SQL TABLES

[MelanieVA]

I am trying to delete the resulting table in this command...<br>
SELECT * FROM main!table INTO TABLE MyTable<br>
<br>
Any ideas...

 

[ServerMan]

After you create a table this way, the SQL Select statement will automatically open the new table for you. You have to close the table before you can delete it.<br>
<br>
I hope this helps.

 

[MelanieVA]

Thanks. It worked..