Provides information about tables with foreign keys on a specified primary key table.
The server must be defined with the CREATE SERVER statement to use this system procedure.
sp_remote_exported_keys @server_name , @sp_name [, @sp_owner ] [, @sp_qualifier ]
None.
Chapter 16, “Accessing Remote Data” and Chapter 17, “Server Classes for Remote Data Access” in the Sybase IQ System Administration Guide
The sp_remote_exported_keys result set includes the database, owner, table, column, and name for both the primary and the foreign key, as well as the foreign-key sequence for the foreign-key column. The result set might vary because of the underlying ODBC and JDBC calls, but information about the table and column for a foreign key is always returned.
To use sp_remote_exported_keys, your database must be created or upgraded using version 12.4.3 or higher of Sybase IQ.
Table 10-57 lists the sp_remote_exported_keys parameters.
Name |
Data type |
Description |
|---|---|---|
@server_name |
varchar |
Server on which the primary-key table is located. Required. |
@sp_name |
varchar(30) |
Table containing the primary key. Required. |
@sp_owner |
varchar |
Owner of primary-key table. Optional. |
@sp_qualifier |
varchar |
Database containing the primary-key table. Optional. |
To get information about the remote tables with foreign keys on the sysobjects table, in the production database, in a server named asetest:
call sp_remote_exported_keys (@server_name='asetest', @sp_name='sysobjects', @sp_qualifier='production')
