There are differences in the types of tables permitted in SELECT INTO statements in Adaptive Server, SQL Anywhere, and SAP Sybase IQ.
Consider this example statement:
select into table1 from table2
Adaptive Server permits table1 to be permanent, temporary or a proxy table. Adaptive Server also supports SELECT INTO EXISTING TABLE.
SQL Anywhere and SAP Sybase IQ permit table1 to be a permanent or a temporary table. A permanent table is created only when you select into table and specify more than one column. SELECT INTO #table, without an owner specification, always creates a temporary table, regardless of the number of columns specified. SELECT INTO table with just one column selects into a host variable.