Table Editor Options

Previous  Top  Next

The Options tab lists the available options when creating a new table.

 

Sybase Anywhere Table Options

 

Sybase Anywhere offers 3 table types: Normal, Global Temporary and Proxy.

 

Table Type

Description

Normal

A normal table resides in the database in the specified tablespace.

 

Global Temporary

A global temporary table has persistent metadata, but volatile data.

 

Proxy

A proxy table is a table on another database server, linked via a Remote Server registration. It can map to an existing table or create a new table at the remote server.

 

The Free space entry allows you to specify the percentage of free space on each page the table occupies. This empty space is used when the row size increases on updating it.