To provide primary key information about remote tables using remote data access.
sp_remote_primary_keys @server_name [, @table_name ] [, @table_owner ] [, @table_qualifier]
The procedure accepts these parameters:
@server_name Selects the server the remote table is located on.
@table_name Selects the remote table.
@table_owner Selects the owner of the remote table.
@table_qualifier Selects the database.
None
None
This stored procedure provides primary key information about remote tables using remote data access.
Because of differences in the underlying ODBC/JDBC calls, the information returned differs slightly in terms of the catalog/database value depending upon the remote data access class that is specified for the server. However, the important information (for example, column name) is as expected.
