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)Connect to the host database as a user with DBA authority.
Execute a CREATE EXISTING TABLE statement.
For more information, see CREATE EXISTING TABLE statement.
Example 1To create a proxy table called p_Employees on the current server to a remote table named Employees on the server named RemoteSA, use the following syntax:
CREATE EXISTING TABLE p_Employees AT 'RemoteSA..GROUPO.Employees'; |
Example 2 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |