Yes and No !!! I say no because temp table are visible neither in the INFORMATION_SCHEMA nor in "SHOW TABLES".
I say yes because you can do "show create table <tbl-name>\G" or "describe <tbl-name>;" to a temp table even if you cannot see it. So the answer is YES !!! -----Original Message----- From: Jay Blanchard [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2008 4:43 PM To: mysql@lists.mysql.com Subject: DESCRIBE temporary table I am not finding a quick reference to this, but I wanted to DESCIBE a TEMPORARY TABLE so that I can make sure the index was properly applied. Can this not be done? TIA! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
