$sql.metaData.getTableTypes

Retrieves the table types available in this database.
Syntax
    $sql.metaData.getTableTypes{jdbcProfileName}
DocumentationRetrieves the table types available in this database. The results are ordered by table type.
The table type is:

TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
:

    Paramter:
      Requieres one parameter, this is your JDBC profile name.
    Returns:
      a ResultSet object in which each row has a single String column that is a table type
    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