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

Dropping external logins Next Page

Working with proxy tables

Location transparency of remote data is enabled by creating a local proxy table that maps to the remote object. You can use a proxy table to access any object (including tables, views, and materialized views) that the remote database exports as a candidate for a proxy table. Use one of the following statements to create a proxy table:


You cannot modify data in a proxy table when you are within a savepoint. See Savepoints within transactions.

Specifying proxy table locations
Creating proxy tables (Sybase Central)
Creating proxy tables with the CREATE EXISTING TABLE statement
Creating a proxy table with the CREATE TABLE statement
Listing the columns on a remote table