EMS logo

Products Navigation

SQL Manager for Oracle

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for Oracle

On-line Documentation

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.