Table Editor

Table Editor is the basic DBISAM Manager tool for working with tables. It allows you to create, edit and drop table's fields and indices, manage table data and much more. Table Editor opens automatically after the table was created and on editing the table (see Create Table and Edit Table for details).

To open the table in the Table Editor find it in the DB Explorer and double-click it.

The Object Explorer at the left of the Table Editor displays all the table subobjects in a form of a tree, showing also field types and index-included fields. Double-clicking any of the tree items opens the object in the appropriate editor. The popup menu of the editor allows you to create/edit/drop a table subobject quickly.

Table Editor Tabs

Fields
This tab is provided for managing table fields. The fields are displayed in a list with their name and properties. A double-click on a field opens the Field Editor for editing the field. A right-click displays the popup menu, allowing you to create new, edit or drop the selected field. The Export Metadata item of the popup menu opens the Export Data Dialog for exporting field metadata to any of 14 available formats.

See Fields for details.
Indices
This tab is provided for managing table indices. The indices are displayed in a list with their names and properties. A double-click on an index opens the Index Editor for editing the index. A right-click displays the popup menu, allowing you to create new, edit or drop the selected index. The Export Metadata item of the popup menu opens the Export Data Dialog for exporting index metadata to any of 14 available formats.

See Indices for details.

Data
This tab displays the table data as a grid, a form or a printable report (see Data Frame for details). The popup menu of this tab and the buttons on the toolbar allow you to Export Data , Import Data , Export Data as INSERT , set the value of the selected record to Null, to the empty string (if it is a string value), or to Now (for Date values). In tables with BLOB fields you can also call the BLOB Editor to view and edit the BLOB fields.

Description
On this tab you can set the table description that can be any optional text. To save the description click the Save Description button on the toolbar or press F2.

DDL
This page displays the SQL statement for creating the table with the parameters you set. This text can't be edited, but it can be copied to the clipboard.

   Table Editor Toolbar

The buttons on the Table Editor toolbar allow you to perform the following operations over the table.

Button	Action
Databases	Drops down with a list of registered databases, allowing you to select the database for the edited table.
Save Description	Saves the table description.
Print Table Metadata	Prints the table metadata (fields, indices, etc.) selected within a dialog window.
Default Size and Position	Brings the window to its default size and position (restricted by the main window).
Select Table	Drops down with a list of database tables, allowing you to select the table for editing.
Table Properties	Opens the Table Properties window for viewing and editing properties, set on table creation.
Start Transaction	Starts a transaction. Transaction starts automatically only on editing table data to prevent unnecessary table locking.
Commit Transaction	Commits the current transaction.
Rollback Transaction	Rollbacks the current transaction.
Export Data ('Data' tab only)	Opens the Export Data Dialog, which allows you to export the table data to file.
Export Data as INSERT Statements ('Data' tab only)	Opens the Export Data As Insert Dialog, which allows you to export the table data to the SQL script as INSERT statements.
Import Data ('Data' tab only)	Opens the Import Data Wizard, which allows you to import data to the table from file.
BLOB Editor ('Data' tab only)	Activates the BLOB Editor for viewing and editing the BLOB field values.

See also:

Field Editor Index Editor