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

In article <1994Aug12.170103.13365@govonca.gov.on.ca>, Stu Miller <millers@govonca.gov.on.ca> wrote: >Hi all, >I am reletively new to Informix so please no flames! > >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? Sounds to me like you are referring to the DROP selection on the TABLE menu of ISQL. Why doesn't ISQL list temporary tables there? Who knows? But a DROP TABLE tablename command in the Query-Language interface should work fine (it does for me). Just keep a DROP TABLE and a CREATE TABLE command in your script and comment-out the ones you don't need for each re-running of the script. While we're at simple things: Use the DBEDIT environment variable to pre-select your User-Editor before you start ISQL. (export DBEDIT=vi)