Creating temporary tables

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

To create a table (Sybase Central)

  1. 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 © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0