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.
Use the SQL Anywhere 12 plug-in to connect to the host database as a user with DBA authority.
In the left pane, double-click Remote Servers.
Select a remote server, and in the right pane click the Proxy Tables tab.
From the File menu choose New » Proxy Table.
Follow the instructions in the Create Proxy Table Wizard.
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|