The help doesn't really say much about this (just that this creates a table and populates it with the results of the query).
So the question here (and hopefully this will lead to an update of the help) is: how is the table created?
From some other posts and my own findings I found that (when just executing a simple SELECT * INTO LOCAL TEMPORARY TABLE #t1 FROM table1):
[NOT] NULL is applied to columns in the new table
Default values are not applied
Checks are not applied
No primary key is created
* select * from sa___describe_query('select * from #t1') can give more information on the new table
Any more information on this is appreciated
11 Feb '13, 05:04