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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Working with database objects » Working with temporary tables


Create temporary tables

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

 To create a table (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to 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