Creating proxy tables

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

Example

To create a proxy table named p_employee on the current server to a remote table named employee on the server named iqdemo1, use the following syntax:

CREATE EXISTING TABLE p_employee 
AT 'iqdemo1..DBA.employee'

Shown is a diagram illustrating how the create existing table statement creates a proxy table that maps to an existing table on the remote server and how Sybase IQ derives the column attributes and index information from the object at the remote location

See CREATE EXISTING TABLE statement in Reference: Statements and Options.