​

Field Details

• ​

  DEPENDENCIES

  public static final String DEPENDENCIES

  Include view dependencies in the output. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  TRUE

  public static final String TRUE

  See Also:

  • Constant Field Values

• ​

  FALSE

  public static final String FALSE

  See Also:

  • Constant Field Values

• ​

  FORCE_SYNCHRONOUS

  public static final String FORCE_SYNCHRONOUS

  If TRUE then the table sizes will wait for read lock before returning. Supported values:

  • TRUE
  • FALSE

  The default value is TRUE.

  See Also:

  • Constant Field Values

• ​

  GET_ACCESS_DATA

  public static final String GET_ACCESS_DATA

  If TRUE then data about the last read, write, alter and create will be returned. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  GET_CACHED_SIZES

  public static final String GET_CACHED_SIZES

  If TRUE then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. This version will return the sizes cached at rank 0, which may be stale if there is a multihead insert occurring. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  GET_SIZES

  public static final String GET_SIZES

  If TRUE then the number of records in each table, along with a cumulative count, will be returned; blank, otherwise. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  REFERENCING_MATERIALIZED_VIEWS

  public static final String REFERENCING_MATERIALIZED_VIEWS

  Include materialized views using this table as a source in the output. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  SKIP_ADDITIONAL_INFO

  public static final String SKIP_ADDITIONAL_INFO

  If TRUE then the response will not populate the additional_info field. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  NO_ERROR_IF_NOT_EXISTS

  public static final String NO_ERROR_IF_NOT_EXISTS

  If FALSE will return an error if the provided tableName does not exist. If TRUE then it will return an empty result. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  SKIP_TEMP_SCHEMAS

  public static final String SKIP_TEMP_SCHEMAS

  If TRUE then the table list will not include tables from SYS_TEMP and other system temporary schemas. This is the default behavior for non-admin users. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values

• ​

  SHOW_CHILDREN

  public static final String SHOW_CHILDREN

  If tableName is a schema, then TRUE will return information about the tables and views in the schema, and FALSE will return information about the schema itself. If tableName is a table or view, SHOW_CHILDREN must be FALSE. If tableName is empty, then SHOW_CHILDREN must be TRUE. Supported values:

  • TRUE
  • FALSE

  The default value is TRUE.

  See Also:

  • Constant Field Values

• ​

  GET_COLUMN_INFO

  public static final String GET_COLUMN_INFO

  If TRUE then column info (memory usage, etc) will be returned. Supported values:

  • TRUE
  • FALSE

  The default value is FALSE.

  See Also:

  • Constant Field Values