EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

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, or press the Ins key;
  • 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 <field_name> context menu item, or simply double-click the field;
  • edit the field properties using the Field Editor dialog.

 

To change the order of table fields:

  • open the table in Table Editor;
  • proceed to the Fields tab there;
  • right-click a field and select the Reorder Fields <field_name> context menu item;
  • edit fields' order using the Reorder Fields 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 <field_name> context menu item;
  • confirm dropping in the dialog window.