Accessing Database Metadata

To support DatabaseMetaData methods, SAP Adaptive Server provides a set of stored procedures that SAP jConnect can call to obtain metadata about a database.

If the stored procedures for providing metadata are not already installed in a SAP Adaptive Server, you can install them using stored procedure scripts provided with SAP jConnect:

sql_server.sql – installs stored procedures on SAP Adaptive Server databases earlier than version 12.0.
sql_server12.sql – installs stored procedures on SAP Adaptive Server database version 12.0.x.
sql_server12.5.sql – installs stored procedures on SAP Adaptive Server database version 12.5.x.
sql_server15.0.sql – installs stored procedures for SAP Adaptive Server 15.0 through 15.5.
sql_server15.7.sql – installs stored procedures for SAP Adaptive Server 15.7 or 15.7 ESD #1.
sql_server15.7.0.2.sql – installs stored procedures for SAP Adaptive Server 15.7 ESD #2 or later.
sql_server16.0.sql – installs stored procedures for SAP Adaptive Server 16.0.
sql_asa.sql – installs stored procedures on the SAP SQL Anywhere database version 9.x.
sql_asa10.sql – installs stored procedures on the SAP SQL Anywhere database version 10.x.
sql_asa11.sql – installs stored procedures on the SAP SQL Anywhere database version 11.x.
sql_asa12.sql – installs stored procedures on the SAP SQL Anywhere database version 12.x.
sql_asa16.sql – installs stored procedures on the SAP SQL Anywhere database version 16.x.

Note: The most recent versions of these scripts are compatible with all versions of SAP jConnect.

See the SAP jConnect for JDBC Installation Guide and SAP jConnect for JDBC Release Bulletin for information about installing stored procedures.

In addition, to use the metadata methods, you must set the USE_METADATA connection property to true (its default value) when you establish a connection.

You cannot obtain metadata from temporary tables in a database.

Note: The DatabaseMetaData.getPrimaryKeys method finds primary keys that are declared in a table definition (CREATE TABLE) or with alter table (ALTER TABLE ADD CONSTRAINT). It does not find keys that are defined using sp_primarykey.