Contents Index sp_remote_exported_keys system procedure sp_remote_primary_keys system procedure

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

sp_remote_imported_keys system procedure


Function 

Provides information about remote tables with primary keys that correspond to a specified foreign key.

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

Syntax 

sp_remote_imported_keys @server_name@sp_name [, @sp_owner ] [, @sp_qualifier ]

Permissions 

None

Side effects 

None

See also 

CREATE SERVER statement

Tables are related by foreign keys

Description 

Foreign keys reference a row in a separate table that contains the corresponding primary key. This procedure allows you to obtain a list of the remote tables with primary keys that correspond to a particular foreign key table. The sp_remote_imported_keys result set includes the database, owner, table, column, and name for the both the primary and the foreign key, as well as the foreign key sequence for the foreign key column. The result set may vary because of the underlying ODBC and JDBC calls, but information about the table and column for a primary key is always returned.

To use the sp_remote_imported_keys stored procedure, your database must be created or upgraded using version 7.0.2 or higher of Adaptive Server Anywhere.

Parameters 

The procedure accepts four arguments:

@server_name    identifies the server the foreign key table is located on. A value is required for this parameter.

@sp_name    identifies the table containing the foreign key. A value is required for this parameter.

@sp_owner    identifies the foreign key table's owner. This parameter is optional.

@sp_qualifier    identifies the database containing the foreign key table. This parameter is optional.

Example 
call sp_remote_imported_keys (
                     @server_name='asetest',
                     @sp_name='sysobjects',
                     @sp_qualifier='production')

Contents Index sp_remote_exported_keys system procedure sp_remote_primary_keys system procedure