Fetching Tables or Stored Procedures

You can use the Schema Browser view to fetch schema objects from a database destination. The schema objects include tables, stored procedures, functions, and packages.

The following figure shows the Schema Browser view with fetched tables and stored procedures.

The fetch action following a query only downloads the descriptors for various fetched objects and not the entire object content. The descriptor contains information, such as the name of a fetched object, associated connection, columns or parameters of the fetched object, data type of the columns or parameters, and so on.

Actual object is downloaded in situations, such as service creation or schema import.

For details on how to fetch tables and stored procedures, see Fetching Tables and Fetching Stored Procedures.