SHOW PROPERTIES Result
A SHOW PROPERTIES command returns a cursor with two main columns: fld_name and fld_value. Also present helper columns that give additional information about property, e.g. if it is System or User, if it is persistent or temporary.
Below are described columns of the result table.
The name of STATUS parameter.
The value of STATUS parameter.
TRUE if this property is system-defined.
TRUE if this property is read only. FALSE if you can change its value using SET PROPERTY command.
TRUE if this property is temporary, i.e. is not stored in the schema.