Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
SQL Anywhere 12.0.0 (Français) » SQL Anywhere Server - SQL Usage » Working with database objects » Working with temporary tables

 

Create temporary tables

You can create temporary tables either with SQL statements or with Sybase Central.

 ♦  To create a table (Sybase Central)

  1. 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.

  2. Right-click Tables and choose New » Global Temporary Table.

  3. Follow the instructions in the Create Global Temporary Table Wizard.

  4. In the right pane, click the Columns tab and configure the table.

  5. Choose File » Save.

 ♦  To create a table (SQL)

  1. Connect to the database as a user with DBA authority.

  2. Execute a CREATE TABLE statement or DECLARE LOCAL TEMPORARY TABLE statement.

 See also
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0