Working with Database Tables

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.

See also

Creating Tables

Deleting Tables

Packing Tables

Renaming Tables

Blob Fields (Memo, Graphic)

Command Line Usage

Printing Data

Working with SQL Queries

Viewing / Editing Table Structure