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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Designing and Creating Databases » Working with database objects » Working with temporary tables

 

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