Schema Management

Many client applications require access to the database catalog to find out the available tables, the column descriptions for the tables, and index information. The OpenAccess SDK Server maps schema information requests to IP schema function calls such as OASQLIP_tables.

The two options for handling the schema in the third-party SQL engine mode are to:

• Implement the IP functions such as OASQLIP_tables to directly call your underlying SQL engine's metadata call that returns the results as defined in this section.
• Create views in your target database that match the specifications for the catalog tables described in this section.

This section contains the specifications for the result sets that must be returned by the IP schema functions such as OASQLIP_tables.