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 Sybase IQ System Administration Guide
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.
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.”
To list all of the Microsoft Excel worksheets available from an ODBC data source named 'excel':
sp_remote_tables excel
To list all of 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
