sp_remote_exported_keys(
  @server_name
  , @sp_name
  [, @sp_owner
  [, @sp_qualifier ] ]
)

This procedure provides information about the remote tables that have a foreign key on a particular primary table. The result set for the sp_remote_exported_keys system procedure 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 foreign key is always returned.

None

None

• CREATE SERVER statement
• Foreign keys

To get information about the remote tables with foreign keys on the SYSOBJECTS table, in the production database, on a server named asetest:

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