After you opened a database, you may create
new tables or work with existing ones, as described below.
You can work with a single table (default mode) or with a group of tables. To work with a single table, just select it in the table list or choose a specific action from the table list context menu. To work with a group of tables, please right-click the table list and choose Multiple Selection, then select needed tables and choose a specific action from the table list context menu; to return to the signle table mode, choose Multiple Selection menu again or close the database. Note that when working with a single table, you have much more possibilities; in other words, not all things which you can do with a single table, can be done with a group of tables. Below, the working with a single table is described.
After
selecting needed table in the table list, the Table window will appear.
In
the Table window, there are several pages:
General
This
page shows general properties of the selected table. Note: The list of
the properties depends on database type.
Data
When
moving to this page, the table data is opened. To
edit the data (delete, insert or modify records), you need to turn data
edit mode on. To delete all records,
right-click the table in the table list and choose Empty... from the drop-down
context menu.
To see the previously
deleted records for databases, which support so called "soft deleting"
(for example, dBase tables), set the corresponding flag (in Table menu). To restore
such records, choose Delete Record again. This works for BDE
connections only.
To refresh the table
data, click the corresponding button above the table data.
A
table, opened in data edit mode: 
Note:
Working with Data page is not recommended for server databases. Use SQL
queries instead.
Fields
This
page shows information about the table fields (columns).
Note: The list of the fields' attributes depends on database type.
Indexes
This
page shows information about the table indices. Note:
For some database types, opened via ADO, indexes are not
shown.
Script
This page shows DDL
script for the table. Note: The completeness and accuracy of the script
depends on database type.
|