What does SELECT * INTO LOCAL TEMPORARY TABLE ... actually do?

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

temporary-table select-into help

asked 11 Feb '13, 05:04

Christian Ha...
697●13●18●33
accept rate: 42%

flat view

One Answer:

active answers oldest answers newest answers popular answers

0	Temporary tables permanent link answered 11 Feb '13, 06:03 Mark 256●5●9●17 accept rate: 20% flat view

Your answer

toggle preview

community wiki:

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

learn more about Markdown

Question tags:

temporary-table ×27
help ×9
select-into ×5

question asked: 11 Feb '13, 05:04

question was seen: 3,020 times

last updated: 11 Feb '13, 06:03

SAP SQL Anywhere

What does SELECT * INTO LOCAL TEMPORARY TABLE ... actually do?

Follow this question

Related questions