Re: How do I drop a temp table in (P)ISQL?

> I had a user ask me how to drop a temp table in ISQL the other day and I > told him that I always just exit and re-load ISQL. I do this to avoid > the possibility of dropping the wrong table! > > It occurred to me that there must be a way to do this using the DROP > command but I'll be dammed if I can get it to work! When I try the DROP > command, the temp table is not in the list of tables that ISQL returns. > The only way I can seem to make changes to the SQL script and re-run it > is to change the name of the temp table in the script or exit and reload ISQL. > > Any suggestions? > Stu Add the command "drop table tabname;" to your sql script. Temp tables do not show up in the list of tables under ISQL -> TABLES, but they can be droped in SQL scripts. Example: select * from customers into temp A; { creates temp A } drop table A; { drops temp A } select * from items into temp A; { reuse the name A } Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # #############################################################################