Online Documentation for SQL Manager for Oracle

Managing fields

The Fields tab is provided for viewing fields represented in the materialized view. Note that the tab is only available when you edit an existing materialized view.


Right-click a field to display the context menu allowing you to export field name list or copy it to clipboard.


Materialized View Editor - Viewing fields


The Fields list provides the following attributes of each field of the materialized view:

Field Name

Field Type

Not Null


Default Value



For details see Fields.


If necessary, you can also use the Field Description area to supply a description for each field.