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

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Usage » Accessing Remote Data » Working with proxy tables

Specifying proxy table locations Next Page

Creating proxy tables (Sybase Central)


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

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

For information about the CREATE EXISTING TABLE statement, see CREATE EXISTING TABLE statement.

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.