To JDBC support DatabaseMetaData methods, Sybase provides a set of stored procedures that jConnect can call for metadata about a database.
These stored procedures must be installed on the server for the JDBC metadata methods to work.
sql_server.sql installs stored procedures on Adaptive Server databases earlier than version 12.0.
sql_server12.sql installs stored procedures on Adaptive Server database version 12.0.x.
sql_server12.5.sql installs stored procedures on Adaptive Server database version 12.5.x.
sql_server15.0.sql installs stored procedures for Adaptive Server 15.0 through 15.5.
sql_server15.7.sql installs stored procedures for Adaptive Server 15.7 or 15.7 ESD # 2.
sql_server15.7.0.2.sql installs stored procedures for Adaptive Server 15.7 ESD #2 or later.
sql_asa.sql – installs stored procedures on the SQL Anywhere database version 9.x.
sql_asa10.sql – installs stored procedures on the SQL Anywhere database version 10.x.
sql_asa11.sql – installs stored procedures on the SQL Anywhere database version 11.x.
sql_asa12.sql – installs stored procedures on the SQL Anywhere database version 12.x.
See the Sybase jConnect for JDBC Installation Guide and Sybase jConnect for JDBC Release Bulletin for complete instructions on 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 get metadata of temporary tables in a database.