Contents Index Working with proxy tables Creating proxy tables (Sybase Central)

ASA SQL User's Guide
  Accessing Remote Data
    Working with proxy tables

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, each separated by either a period or a semicolon. The semicolon delimiter allows filenames and extensions to be used in the database and owner fields.

The syntax of the AT clause is

... AT 'server.database.owner.table-name'
Examples: 

The following examples illustrate the use of location strings:

'testasa..DBA.employee'
'ASEServer.pubs2.dbo.publishers'
'excel;d:\pcdb\quarter3.xls;;sheet1$'
'access;\\server1\production\inventory.mdb;;parts'

Contents Index Working with proxy tables Creating proxy tables (Sybase Central)