ASA SQL Reference
System Procedures and Functions
System and catalog stored procedures
To provide primary key information about remote tables using remote data access.
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.
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 the remote data access class that is specified for the server. However, the important information (for example, column name) is as expected.
Sybase Supported by Open Client/Open Server.