Creating a SQL Anywhere or a Sybase IQ Temporary Table

You can create SQL Anywhere and Sybase IQ temporary tables.

1. In the Databases folder in Enterprise Explorer, under the database connection profile, expand the tree for a database, expand the Schemas folder and then the tree for the appropriate schema owner.
2. Right-click the Tables folder and select New > Temporary Table.
3. Enter a Table Name.
4. Define the columns and rows for the table.
5. (Optional) Enter comments about the table.
6. Click Next.
7. Define the following options:

   Option	Description
   Page Free Space	Specify the percentage of free space to be reserved for each table page. The value is an integer between 0 and 100.
   Optional Primary Key	Indicate the name of the primary key.
   Index Option	Create a clustered index.
   Transactional	Identify whether the table is affected by commit or rollback.
   Non-Transactional	Identify whether the non-transactional table is affected by commit or rollback.

8. Click Next and specify save and execution properties.

   Field	Description
   Generate Script	Generate a SQL file for the table.
   Enter or Select the Parent Folder	Specify an existing project or create a new project in which to save the SQL file.
   File Name	Enter the file name in which to store the SQL code.
   Execute Immediately	Execute the SQL code immediately. If you do not select this option, you must complete execution of the SQL file later to create the table.
   Open in Editor After Creation	Create the table and open it in the Table Schema Editor.

9. Click Finish.

For product-related issues, contact Sybase Technical Support at 1-800-8SYBASE. Send your feedback on this help topic directly to Sybase Technical Publications: pubs@sybase.com