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.

fld_name

The name of STATUS parameter.

fld_value

The value of STATUS parameter.

fld_is_system

TRUE if this property is system-defined.

fld_is_read_only

TRUE if this property is read only. FALSE if you can change its value using SET PROPERTY command.

fld_is_temporary

TRUE if this property is temporary, i.e. is not stored in the schema. For example IOEncoding property of DB/Table/Field is never saved to DB.

fld_is_inherited

TRUE if value of this property is inherited from the parent object. Usually this is for set of Encoding properties of Db/Table/Field chain.