Specify Proxy Table Locations

The AT keyword is used with both CREATE TABLE and CREATE EXISTING TABLE to define the location of an existing object.

The location string has four components that are separated by either a period or a semicolon. Semicolons allow filenames and extensions to be used in the database and owner fields.

SeeSQL Anywhere 11.0.1 > SQL Anywhere Server - SQL Usage > Remote Data and Bulk Operations > Accessing remote data > Working with proxy tables > Specify proxy table locations.

Example

The following example illustrate the use of location strings:

  • Sybase IQ:

'testiq..DBA.employee'
Parent topic: Proxy Tables