Creating a Proxy Table

Create a proxy table to access data on remote servers.

A proxy table is a user table that allows you to access data in a remote table, view, remote procedure call, directory, or file. A proxy table has all the attributes of a user table, such as columns, indexes, and triggers, but it does not contain any data locally.
Note: Only a database owner or a user with create table permission can create a table.
  1. In the Perspective Resources view, select the servers on which the table is to be created, then click the drop-down arrow next to a server name and select Administration Console.
  2. In the left pane of the Administration Console, expand ASE Servers > Schema Objects > Tables and select Proxy Tables
  3. Select New.
    You see the Add Proxy Table wizard.
  4. In the Introduction window, select the server, database, and owner for the new table.
  5. Enter a name for the proxy table.
  6. Enter the SQL statements for the new table and related table objects.
  7. (Optional) Click Summary to verify your selected options.
  8. Click Finish to create the proxy table.
Parent topic: Manage Tables
Related tasks
Creating a User Table