Purpose

Determines which type of metadata information is included in result sets when an application calls DatabaseMetaData methods.

Valid values

0 | 2

Behavior

If set to 0, result sets do not contain synonyms.

If set to 2, result sets contain synonyms that are returned from the following DatabaseMetaData methods: getFunctions(), getTables(), getColumns(), getProcedures(), getProcedureColumns(), and getFunctionColumns()

Data source method

public Integer getCatalogOptions()

public void setCatalogOptions(Integer)

Default

0

Data type

Int