Proxy Tables

Location transparency of remote data is enabled by creating a local proxy table that maps to the remote object.

See SQL Anywhere Server - SQL Usage > Remote data and bulk operations > Accessing remote data > Working with proxy tables.

• Specify Proxy Table Locations
  The AT keyword is used with both CREATE TABLE and CREATE EXISTING TABLE to define the location of an existing object.
• Create Proxy Tables
  The CREATE EXISTING TABLE statement creates a proxy table that maps to an existing table on the remote server.
• CREATE TABLE Statement
  The CREATE TABLE statement creates a new table on the remote server, and defines the proxy table for that table when you use the AT option.
• List the Columns On a Remote Table
  The sp_remote_columns system procedure produces a list of the columns on a remote table and a description of those data types.