The AT keyword is used with both the CREATE TABLE and the CREATE EXISTING TABLE statements 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 file names and extensions to be used in the database and owner fields.
The syntax of the AT clause is:
... AT 'server.database.owner.table-name'
If the data source is Adaptive Server Enterprise, database specifies the database where the table exists. For example master or pubs2.
If the data source is SAP Sybase IQ, this field does not apply; leave it empty.
If the data source is Excel, Lotus Notes, or Access, you must include the name of the file containing the table. If the file name includes a period, use the semicolon delimiter.
The following examples illustrate the use of location strings:
SAP Sybase IQ:
'RemoteSA..GROUPO.Employees'
Adaptive Server Enterprise:
'RemoteASE.pubs2.dbo.publishers'
Excel:
'RemoteExcel;d:\pcdb\quarter3.xls;;sheet1$'
Access:
'RemoteAccessDB;\\server1\production\inventory.mdb;;parts'