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

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? TIA Stu Miller -- ______________________________________________________________________ _ / \\._ _|_ _.._ o _ Stu Miller - Mineralogist \\_/| | |_(_|| |(_) internet: millers@ndm.gov.on.ca ____ _____ ___ e-mail: miller_s@torv05.ndm.gov.on.ca / ___| ____/ _ \\ voice: (705)670-5635 FAX:(705)670-3047 | | _| _|| | | | _ | |_| | |__| |_| | _ _ ._ o _ _ _ / _ ._ _|_ ._ _ \\____|_____\\___/ _>(/_| \\/ |(_(/__> \\_(/_| | |_ | (/_ Geoscience Laboratories Ministry of Northern Development & Mines 933 Ramsey Lake Road, Sudbury, Ontario, CANADA P3P 1G9 -----------------------------------------------------------------------