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

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Accessing remote data » Working with proxy tables

 

Creating proxy tables (Sybase Central)

Use one of the following procedures to create a proxy table. 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 as a user with DBA authority.

  2. In the left pane, double-click Remote Servers.

  3. Select a remote server, and in the right pane click the Proxy Tables tab.

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

  5. Follow the instructions in the Create Proxy Table Wizard.