ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
Returns a list of the tables on a server.
The server must be defined with the CREATE SERVER statement to use this system procedure.
sp_remote_tables server_name [, table_name ] [, table_owner ] [, table_qualifier ] [, with_table_type ]
None
None
Server Classes for Remote Data Access
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 owned by fred in the production database in an Adaptive Server Enterprise server named asetest:
sp_remote_tables asetest, null, fred, production