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.

See SQL Anywhere Server - SQL Usage > Remote data and bulk operations > Accessing remote data > Working with proxy tables > Specify proxy table locations.

Note: This reference points to SQL Anywhere documentation.

Example

The following example illustrate the use of location strings:

  • Sybase IQ:

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