You can create a global temporary table using Sybase Central. Perform this task to create global temporary tables when you want to work on data without having to worry about row locking, and to reduce unnecessary activity in the transaction and redo logs.
You must have the CREATE TABLE system privilege to create tables owned by you. You must have the CREATE ANY TABLE or CREATE ANY OBJECT system privilege to create tables owned by others.
In Sybase Central, use the SQL Anywhere 16 plug-in to connect to the database.
Right-click Tables and click 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.
Click File » Save.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|