Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Tables, views, and indexes » Temporary tables


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.


DBA authority.

Context and remarks


 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.


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.



 See also