Alternative Table Editing

dbForge Studio enables to edit table structure in two ways. Use whichever method you like more.

  • First, you can do it directly from Database Explorer. Expand the table node, then expand the Columns, Constraints, or Indexes node. You can double-click an item to open a dialog where all parameters of the item are accessible for editing. Once you close the dialog the changes are applied to object.

  • The other way to alter table structure is to open a document for a table. To do this, right-click a table in Database Explorer and select Edit Table from the shortcut menu. Table structure appears in document area with available tabs. To edit a table element, switch to tab that contains it and double-click it. Corresponding dialog appears where you can make changes to item. To apply the changes, close the dialog and click Save button.

You can use these two ways of editing tables simultaneously.

Note
Changes made through Database Explorer are instantly applied and reflected in the document. When you alter a table using document area, changes are applied only when you save the document.