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 Sybase IQ System Administration Guide
This procedure provides information about the remote table that has a foreign key on a particular primary key table. The sp_remote_exported_keys stored procedure's 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 may 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 the sp_remote_exported_keys stored procedure, your database must be created or upgraded using version 12.4.3 or higher of Sybase IQ.
Table 9-29 list the sp_remote_exported_keys arguments.
Name |
Data type |
Description |
|---|---|---|
@server_name |
varchar |
Server the primary key table is located on. 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')
