It may be helpful when you are configuring your Sybase IQ to get a list of the remote tables available on a particular server. The sp_remote_tables procedure returns a list of the tables on a server.
sp_remote_tables servername
[,tablename]
[, owner ]
[, database]
If tablename, owner, or database is given, the list of tables is limited to only those that match.
For example, to get a list of all of the tables in the production database in an ASE named asetest, owned by 'fred':
sp_remote_tables asetest, null, fred, production
For more information, see the sp_remote_tables system procedure in Sybase IQ Reference Manual.
