EMS logo

Products Navigation

SQL Manager for DB2

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for DB2

On-line Documentation

Fields


Table fields are managed within the Fields tab of Table Editor.

 

 

Creating Fields

 

To create a new table field:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click the tab area and select the New Field context menu item;
  • define the field properties using the Field Editor dialog.

 

Editing Fields

 

To edit an existing table field:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click the field and select the Edit Field context menu item, or simply double-click the field;
  • edit the field properties using the Field Editor dialog.

 

Dropping Fields

 

To drop a table field:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click the field and select the Drop Field context menu item;
  • confirm dropping in the dialog window.

Note: Dropping field operation is available starting from DB2 version.