homehome previousprevious nextnext
 
Fields

Table fields are managed on the Fields tab of the Table Designer. Just simply click a field for editing. A right-click displays the popup menu or using the toolbar below, allowing you to create new, insert and drop the selected field.

Add Field

To add a field to the table

  • Open the table in the Table Designer.
  • Open the Fields tab.
  • Right-click and select the Add Field from the popup menu or click the Add Field from the toolbar.
  • Edit field properties.

To add a new field with modification as one of the existing fields

  • Open the table in the Table Designer.
  • Open the Fields tab.
  • Select field.
  • Right-click and select the Duplicate Field from the popup menu.
  • Edit field properties.

Insert Field

To insert a field above an existing field

  • Open the table in the Table Designer.
  • Open the Fields tab.
  • Select field.
  • Right-click and select the Insert Field from the popup menu or click the Insert Field from the toolbar.
  • Define field properties in the empty row.

Edit Field

To edit the table field

  • Open the table in the Table Designer.
  • Open the Fields tab.
  • Simply click on the field to edit.

Delete Field

To delete the table field

  • Open the table in the Table Designer.
  • Open the Fields tab.
  • Right-click and select the Delete Field from the popup menu or click the Delete Field from the toolbar.
  • Confirm deleting in the dialog window.

See also:
Setting Field Name and Data Type
Setting Field Size and Decimals
Setting Field Flags
Setting Other Field Properties

 

Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
PGSQL TM is a trademark of PGSQL AB in the United States and other countries.