Database Tour Documentation Contents Index

Viewing / Editing Table Structure

Top Previous Next

Fields

Field (column) structure information of the selected table is given in Fields page of the Table window.

To quickly move to a field data just click twice the needed field row (if the table is open).

There are functions to add, delete, rename, and resize fields. But in any case you can try to do this by queries and / or exporting.

Note

1. When editing the table field structure, make sure that your changes will not have influence on existing indexes.

2. Availability of some additional information about fields (required flag (ability to contain NULL values), default value etc.) depends on database types and used database engine.

3. Different database types may have different set of filed attributes.

4. When some columns in Fields table are dimmed, this means that the appropriate information is unavailable or has no sense for this database (table) type.

Indexes

Index structure information of the selected table is given in Indexes page of the Table window.

To quickly sort the table by an index data just click twice the needed index row (if the table is opened).

To delete an index, select it in the index grid and click the Delete Index button or press DELETE. If this button remains disabled after you selected index, then you cannot delete this index.

To create a new index, click Add Index button or press INSERT. After the new index window will be shown, select index fields and required index options and click OK. If the index must be named, the program will propose you to enter the index name, just type it and click OK.

To regenerate indexes of dBase or Paradox table, click the corresponding button or choose menu Table | Utilities | Regenerate Indexes. To regenerate indexes of all dBase and Paradox tables in the selected directory, choose menu Tools | BDE Tools | Regenerate Indexes of All Tables....

Note

1. In this version of the program, the functions for editing an index structure, as well as regenerating indexes, work only if the database was opened via BDE. In case of using other database engines, use queries for this.

2. You cannot remove a primary index in this way.

3. Not all database types support all index options.

4. Sometimes you cannot create a primary index, even if the database server supports primary indexes. Often you can create a primary index only when creating a new table.

5. Sometimes (for example, when connecting via ADO), the information about indexes may be unavailable for some database types.

6. Anyway, you can try to add or delete indexes using queries.

Field and index information can be printed, copied or saved to file.

It is recommended to correct (by using a mouse) the widths of all columns before printing to be sure that the printed page will include all the columns.

Referential integrity (currently for Paradox only)

In this version of the program, this information is accessible only if the database was opened via BDE. To access the referential integrity information of the selected table, use the corresponding item from Table | Utilities, which becomes active when the referential integrity exists for this table.

See also

 Database Objects