show TEMPORARY tables ???

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Hi there,

Is there a way to list the TEMPORATY tables?
I have tried SHOW TABLES, but this command only list the regular tables.

Thank you very much for your answer.


Re: show TEMPORARY tables ???

Quoted text here. Click to load it

No.  MySQL will not SHOW you tables created with the TEMPORARY keyword.

Note that there is no reason why you can't create ordinary tables instead
and then use them temporarily by DROPing them when you are finished.

I make extensive use of small TEMPORARY tables in automated scripts.  While
I am developing these scripts, I leave out the TEMPORARY keyword so that I
can examine these tables an debug using the normal MySQL facilities.  When I
am satisfied that my scripts are functioning as advertised, I then add the
TEMPORARY keyword back to my CREATE TABLE statements. When used properly,
TEMPORARY tables can speed up certain processes dramatically.   But when you
need to actually see what is going on, you will have to leave the TEMPORARY

Thomas Bartkus

Site Timeline