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

This system procedure provides primary key information about remote tables using remote data access.

Because of differences in the underlying ODBC calls, the information returned differs slightly from the catalog/database value depending upon the remote data access class that is specified for the server.

None

None

• Remote data access
• Server classes for remote data access
• CREATE SERVER statement

The following example returns information about the primary keys in tables owned by DBA in a SQL Anywhere remote server named RemoteSA.

CALL sp_remote_primary_keys( 'RemoteSA', null, 'DBA' );

To get a list of the primary keys in all the tables owned by Fred in the production database in an Adaptive Server Enterprise server named RemoteASE:

CALL sp_remote_primary_keys( 'RemoteASE', null, 'Fred', 'production' );