sp_remote_exported_keys system procedure

Provides information about tables with foreign keys on a specified primary table.

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

Syntax

sp_remote_exported_keys(
@server_name
, @table_name
[, @table_owner
[, @table_qualifier ] ]
)

Arguments

@server_name Use this CHAR(128) parameter to specify the server the primary table is located on.
@table_name Use this CHAR(128) parameter to specify the table containing the primary key.
@table_owner Use this optional CHAR(128) parameter to specify the primary table's owner. The default is '%'.
@table_qualifier Use this optional CHAR(128) parameter to specify the database containing the primary table. The default is '%'.

Result set

Column name	Data type	Description
pk_database	CHAR(128)	The database containing the primary key table.
pk_owner	CHAR(128)	The owner of the primary key table.
pk_table	CHAR(128)	The primary key table.
pk_column	CHAR(128)	The name of the primary key column.
fk_database	CHAR(128)	The database containing the foreign key table.
fk_owner	CHAR(128)	The foreign key table's owner.
fk_table	CHAR(128)	The foreign key table.
fk_column	CHAR(128)	The name of the foreign key column.
key_seq	SMALLINT	The key sequence number.
fk_name	CHAR(128)	The foreign key name.
pk_name	CHAR(128)	The primary key name.

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.

Privileges

Side effects

Example

Discuter à propos de cette page dans DocCommentXchange.