In addition to the Adaptive Server Enterprise Catalog stored procedures, there are other system and catalog stored procedures. The following table lists the ones you are most likely to use. For a complete list, see Chapter 10, “System Procedures” in Sybase IQ Reference Manual.
Procedure name |
Purpose |
|---|---|
sp_remote_columns |
List remote tables columns and their data types |
sp_remote_exported_keys |
Get information about remote tables with foreign keys on a specified primary key table |
sp_remote_imported_keys |
Get information about remote tables with primary keys for a specified foreign key |
sp_remote_primary_keys |
Get primary key information about remote tables |
sp_remote_tables |
List tables on a remote server |
sp_servercaps |
Display information about a remote server's capabilities |
