ASA SQL User's Guide
Accessing Remote Data
Location transparency of remote data is enabled by creating a local proxy table that maps to the remote object. Use one of the following statements to create a proxy table:
If the table already exists at the remote storage location, use the CREATE EXISTING TABLE statement. This statement defines the proxy table for an existing table on the remote server.
If the table does not exist at the remote storage location, use the CREATE TABLE statement. This statement creates a new table on the remote server, and also defines the proxy table for that table.
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