Returns a list of the tables on a server.
sp_remote_tables servername [, tablename ] [, owner ] [, table_qualifier ] [, with_table_type ]
The server must be defined with the CREATE SERVER statement to use this system procedure.
None.
Chapter 16, “Accessing Remote Data” and Chapter 17, “Server Classes for Remote Data Access” in the Sybase IQ System Administration Guide
It might be helpful when configuring your database server to get a list of the remote tables available on a particular server. sp_remote_tables 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 parameter 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 parameter is available only for databases created in Adaptive Server Anywhere 7.0.2 and higher. If you use this parameter 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 is limited to only those that match the parameters.
You cannot capture output from this procedure in a file.
If you use the redirection operator, you receive the message “Cursor
is restricted to Fetch Next operations.”
Lists all the Microsoft Excel worksheets available from an ODBC data source named “exce”:
sp_remote_tables excel
Lists all the tables in the production database in an Adaptive Server Enterprise server named asetest, owned by user fred:
sp_remote_tables asetest, null, fred, production
