You can create temporary tables either with SQL statements or with Sybase Central.
Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority or as the owner of the table.
Right-click Tables and choose New » Global Temporary Table.
Follow the instructions in the Create Global Temporary Table Wizard.
In the right pane, click the Columns tab and configure the table.
Choose File » Save.
Connect to the database as a user with DBA authority.
Execute a CREATE TABLE statement or DECLARE LOCAL TEMPORARY TABLE statement.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|