The Table Structure Manager dialog box allows you to compare and edit the structure of multiple selected tables with respect to a base table. Using this feature, you can perform multi-table comparison through a customizable grid/browser view.
Select Tables to Compare
Base Table
Select the base table from this drop-down list. This list consists of all the tables that are currently open in a session. The base table is the table whose structure will be used as a template for other comparison tables; it will be the first table displayed.
Compare With
Select the table or tables which you will compare with the already selected base table.
Display Object Columns
Select this check box to add a geometry object column at the end of the column list. By default the object columns are not shown.
Case Sensitive
Select this check box to match field names of the same case (for example, "ZIP" will not match "Zip" or "zip") across multiple tables.
Text Report
Use this button to generate a table structure summary report of the base table when compared to another table or tables.
Match by Field Name
Select this check box to display fields with the same name in the same row. This enables you to check whether fields across multiple tables are named identically. It also enables a simple visual comparison of the field types of matching fields. For example, three tables may have "EmployeeID" fields of differing types (Character(10), Character(20) and Integer).
Match by Column Order (Order View)
Select this check box to display fields in their individual table orders. This option enables easy visual comparison of whether the fields are ordered identically across multiple tables.
Add
Use this button to add a new field of a particular type to any table. The new field will be added to the end of each table. This option requires a single field selection in each target table, which can be a populated or blank field, neither of which will be altered.
Delete
Use this button to delete a field of any table.
Copy
Use this button to copy a field from one table to another.
Edit
Use this button to rename a field, change the type of field, and change the column ordering for any table.
See Also: