I assume that remarks field will be always be empty for your Phoenix tables.
This table description feature you are using is based on JDBC Metadata API.
Phoenix SQL does not support comments on tables, other SQL implementations may support that.
The JDBC Metadata API would return the table comment in the remarks field, (docs)
getTables
ResultSet getTables(String catalog,
String schemaPattern,
String tableNamePattern,
String[] types)
throws SQLException
Retrieves a description of the tables available in the given catalog. Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE
, TABLE_CAT
, TABLE_SCHEM
and TABLE_NAME
.
Each table description has the following columns:
- TABLE_CAT String => table catalog (may be
null
) - TABLE_SCHEM String => table schema (may be
null
) - TABLE_NAME String => table name
- TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM".
- REMARKS String => explanatory comment on the table
- TYPE_CAT String => the types catalog (may be
null
) - TYPE_SCHEM String => the types schema (may be
null
) - TYPE_NAME String => type name (may be
null
) - SELF_REFERENCING_COL_NAME String => name of the designated "identifier" column of a typed table (may be
null
) - REF_GENERATION String => specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be
null
)
See this discussion for further details. https://github.com/forcedotcom/phoenix/issues/183