sp_remote_primary_keys system procedure

Function

Provides primary key information about remote tables using remote data access.

Syntax

sp_remote_primary_keys @server_name [, @table_name ] [, @table_owner ] [, @table_qualifier] 

Accepts these parameters:

@server_name Selects the server on which the remote table is located.

@table_name Selects the remote table.

@table_owner Selects the owner of the remote table.

@table_qualifier Selects the database.

Permissions

None

Side effects

None

Description

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.

Standards and compatibility

Sybase Supported by Open Client/Open Server.