Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Accessing remote data » Working with proxy tables


Create proxy tables with the CREATE EXISTING TABLE statement

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.

 To create a proxy table with the CREATE EXISTING TABLE statement (SQL)
  1. Connect to the host database as a user with DBA authority.

  2. Execute a CREATE EXISTING TABLE statement.

For more information, see CREATE EXISTING TABLE statement.

 Example 1
 Example 2