Contents Index Specifying proxy table locations Creating proxy tables with the CREATE EXISTING TABLE statement

ASA SQL User's Guide
  Accessing Remote Data
    Working with proxy tables

Creating proxy tables (Sybase Central)

You can create a proxy table using either Sybase Central or a CREATE EXISTING TABLE statement.

The CREATE EXISTING TABLE statement creates a proxy table that maps to an existing table on the remote server. Adaptive Server Anywhere derives the column attributes and index information from the object at the remote location.

To create a proxy table (Sybase Central)

  1. Connect to the host database from Sybase Central.

  2. In the left pane, open the Remote Servers folder.

  3. In the right pane, click the Proxy Tables tab.

  4. From the File menu choose New > Proxy Table.

  5. Follow the instructions in the wizard.

Tip 
Proxy tables are displayed in the right pane on the Proxy Tables tab when their remote server is selected in the left pane. They also appear in the Tables folder. They are distinguished from other tables by a letter P on their icon.

Contents Index Specifying proxy table locations Creating proxy tables with the CREATE EXISTING TABLE statement