Contents Index sp_remote_imported_keys system procedure sp_remote_tables system procedure

ASA SQL Reference
  System Procedures and Functions
    System and catalog stored procedures

sp_remote_primary_keys system procedure


Function 

To provide primary key information about remote tables using remote data access.

Syntax 

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

The procedure accepts five 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.

database_name    Selects the database.

Permissions 

None

Side effects 

None

Description 

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 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.


Contents Index sp_remote_imported_keys system procedure sp_remote_tables system procedure