Re: [Q] close temporary tables explicitly

Posted in 1998

Peter Kolmhofer — Mon, 09 Feb 1998 08:45:35 +0100 — source: Informix-list mailing list archive (1991-1998)

SeungLak Choi wrote: > I know temporary tables are closed implicitly when session is closed. > > However, I am using a great number of temporary tables within a > session. > So, I want to close temporary tables which are not needed any more. > > How can I do it? > > Thanks in advance SeungLak, you can use "DROP TABLE your_temp_table;". Peter ______________________ Mag. Peter Kolmhofer DBA Porsche Informatik (Austria) eMail: kop@porsche.co.at