Online Documentation for SQL Manager for DB2

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.