Creating a global temporary table

Create a global temporary table using Sybase Central. Perform this task to create global temporary tables when you want to work on data locally, without having to worry about row locking, and to reduce unnecessary activity in the transaction and redo logs.

Prerequisites

DBA authority.

Context and remarks

Many.

 Create a global temporary table using Sybase Central

  1. Connect to the database using the SQL Anywhere 12 plug-in

  2. Right-click Tables and click 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. Click File » Save.

Results

A global temporary table is created. The global temporary table definition is stored in the database until it is specifically dropped, and is available for use by other connections.

Next

None.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1