Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 6 of 6 total

Where can I find column definitions for temporary tables?

Tue, Mar 1 2011 5:59 PM	Permanent Link
Chris B	Hi, Looking at build 2.05B3 How can I access column definitions for temporary tables? As far as I can tell, they don't appear in Information.TableColumns. Is there an equivalent to Information.TableColumns for temporary tables? Regards, Chris
Wed, Mar 2 2011 2:26 AM	Permanent Link
Uli Becker	Chris, > Looking at build 2.05B3 > How can I access column definitions for temporary tables? > As far as I can tell, they don't appear in Information.TableColumns. At least with version 2..3 that works fine for me. Are you using the same session to query the information database as you used to create the temp-table? Uli
Wed, Mar 2 2011 3:20 PM	Permanent Link
Chris B	Sure am
Wed, Mar 2 2011 4:35 PM	Permanent Link
Chris B	Doing the below returns an empty information.tablecolumns resultset CREATE TEMPORARY TABLE TMP_11030214144294315508 AS SELECT * FROM ( SELECT * FROM PRODUCTS ORDER BY PRODUCTCODE JOINOPTIMIZECOSTS ) ABCKIDS WITH DATA! select * from TMP_11030214144294315508! select * from information.tablecolumns where tablename like 'TMP%'!
Fri, Mar 4 2011 10:36 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Chris, << How can I access column definitions for temporary tables? As far as I can tell, they don't appear in Information.TableColumns. >> No, they don't. It is normally assumed that temporary tables are temporary and explicit enough that this type of information isn't relevant or useful. -- Tim Young Elevate Software www.elevatesoft.com
Sat, Mar 5 2011 3:17 AM	Permanent Link
Uli Becker	Chris, sorry about my posting: I tried this in EDB-Manager and forgot the key-word "Temporary" That's why it "worked" for me. Uli