You can read data type name and other parameters from the COLUMNS table: https://h2database.com/html/systemtables.html#information_schema_columns DATA_TYPE column now contains the name as required by the SQL Standard.
For ARRAY data types there is an additional table with definitions of elements: https://h2database.com/html/systemtables.html#information_schema_element_types For row value data types you need another additional table with definitions of fields: https://h2database.com/html/systemtables.html#information_schema_fields All these tables in H2 2.*.* are compliant with the SQL Standard. Non-standard ENUM data types have an own non-standard table with possible values: https://h2database.com/html/systemtables.html#information_schema_enum_values In old versions of H2 INFORMATION_SCHEMA.COLUMNS.DATA_TYPE was incorrectly used for JDBC type code. H2 2.*.* doesn't report JDBC-specific information in the INFORMATION_SCHEMA, but you can read it from JDBC database metadata, if you wish. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/e87f345e-df94-4609-a868-dfd77faa3aa8n%40googlegroups.com.
