Defining the storage location of individual objects

Defining individual object storage locations is done by means of the system procedure sp_addobjectdef or the use of the at pathname syntax. This procedure allows you to associate a remote object with a local proxy table name. The remote object may or may not exist before you do the mapping. Complete syntax for sp_addobjectdef is provided in the Adaptive Server Reference Manual.

An easier method for defining storage locations is with the create proxy_table command.

create proxy_table <table_name>
	[external file] at "pathname"