Contents Index sp_remote_primary_keys system procedure sp_servercaps system procedure

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sp_remote_tables system procedure


Function 

Returns a list of the tables on a server.

The server must be defined with the CREATE SERVER statement to use this system procedure.

Syntax 

sp_remote_tables server_name [, table_name ] [, table_owner ] [, table_qualifier ] [, with_table_type ]

Permissions 

None

Side effects 

None

See also 

Accessing Remote Data

Server Classes for Remote Data Access

CREATE SERVER statement

Description 

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.

Standards and compatibility 
Examples 

Contents Index sp_remote_primary_keys system procedure sp_servercaps system procedure