Specifying proxy table locations

The AT keyword is used with both CREATE TABLE and CREATE EXISTING TABLE to define the location of an existing object. This 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”Specify proxy table locations” in SQL Anywhere Server - SQL Usage.

Example

The following example illustrate the use of location strings:

'testiq..DBA.employee'