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

asked 11 Feb '13, 05:04

Christian%20Hamers's gravatar image

Christian Ha...
647131630
accept rate: 42%


permanent link

answered 11 Feb '13, 06:03

Mark's gravatar image

Mark
2565917
accept rate: 20%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×26
×9
×5

question asked: 11 Feb '13, 05:04

question was seen: 2,670 times

last updated: 11 Feb '13, 06:03