$sql.metaData.getSchemas

Retrieves the schema names available in this database.
Syntax
    $sql.metaData.getSchemas{jdbcProfileName}
DocumentationRetrieves the schema names available in this database. The results are ordered by schema name.

The schema column is:

TABLE_SCHEM String => schema name
TABLE_CATALOG String => catalog name (may be null)
:

    Paramter:
      Requieres one parameter, this is your JDBC profile name.
    Returns:
      a ResultSet object in which each row is a schema decription
    Throws:
      SQLException - if a database access error occurs
Examples
GroupSQL
Minimum required transaction-mode:NONE
Required scripting permission of the developerPERMISSION_FL_BASIC
Minimum parameters1
Maximum parameters 1
[Index] | [API-Index] | [Index-de] | © SITEFORUM Group, Germany | powered by SITEFORUM