sp_remote_imported_keys( 
server_name
 , sp_name
 [, sp_owner
 [, sp_qualifier ] ]
)

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 table. The sp_remote_imported_keys result set includes the database, owner, table, column, and name for both the primary and the foreign key, and the foreign key sequence for the foreign key columns. 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.

None

None

• CREATE SERVER statement
• Foreign keys

The following example uses named parameters when calling the procedure, and returns the tables with primary keys that correspond to a foreign key on the SYSOBJECTS table in the asetest server:

CALL sp_remote_imported_keys(
     @server_name='asetest',
     @sp_name='sysobjects',
     @sp_qualifier='production' );