System and catalog stored procedures
978
None
"Accessing Remote Data" on page 893 of the book ASA User’s Guide
"Server Classes for Remote Data Access" on page 925 of the book ASA
User’s Guide
"CREATE SERVER statement" on page 464
It may be helpful when you are configuring your database server to get a list
of the remote tables available on a particular server. This procedure returns a
list of the tables on a server.
The procedure accepts five parameters:
server_name Selects the server the remote table is located on.
table_name Selects the remote table.
table_owner Selects the owner of the remote table.
table_qualifier Selects the database.
with_table_type Selects the type of remote table. This argument is a bit
type and accepts two values, 0 (the default) and 1. You must enter the value
1 if you want the result set to include a column that lists table types.
The
with_table_type
argument is only available for databases created in
Adaptive Server Anywhere 7.0.2 and higher. If you use this argument with
an older database, the following error message is returned:
Wrong number of parameters to function ’sp_remote_tables’
If a table, owner, or database name is given, the list of tables will be limited
to only those that match the arguments.
♦
Sybase Supported by Open Client/Open Server.
♦ To get a list of all of the Microsoft Excel worksheets available from an
ODBC datasource named ’excel’:
sp_remote_tables excel
♦ To get a list of all of the tables in the ’production’ database in an
Adaptive Server Enterprise server named "asetest", owned by
fred
:
sp_remote_tables asetest, null, fred, production
sp_servercaps system procedure
Displays information about a remote server’s capabilities.
The server must be defined with the CREATE SERVER statement to use this
system procedure.
Side effects
See also
Description
Standards and
compatibility
Examples
Function
To Next Page
Loading...