VERIFIED SOLUTION i

Something a bit more Advanced: The Table Structure Manager

MapInfo Pro™ Monthly Journal
Work Smarter, Not Harder with the Table Structure Manager
 
User-added imageMapInfo Pro v12.0, 12.5 and v15.0 includes a tool which allows you to compare and modify the structure of multiple tables at once. This tool is called the Table Structure Manager. Those of you who have used the Discover 3D  products may be familiar with this already as this was previously supplied with these add-on solutions. 

Using the Table Structure Manager

To access the Table Structure Manager, right-click on a table in the Table List window. 

User-added image
The Table Structure Manager dialog box appears.

User-added image

Above: The structure of the chosen table appears. This is the reference to which other tables can now be compared. If needed it is possible to change the reference by choosing a different table from the Base Table drop down list.

Below: Use the Ctrl and Shift keys select one or more tables to compare.

User-added image

Modifying the Structure of the Tables

The Table Structure Manager allows you to do more than just compare the structure of the tables. It is also possible to add, remove, copy and change the data columns of your tables. What makes this really useful is you can work across multiple tables at the same time! 

User-added image

Add

This option allows you to add new fields to one or more tables.

Delete

This option allows you to delete fields from one or more tables. In the screen shot below, different fields have been selected for deletion. Note that a warning is given. 

User-added image

Before deleting a warning is given as this operation cannot be undone. 

Copy 

The Copy command allows you to copy one or more fields from one table to one or more of the other chosen tables. 

User-added image

Three fields have been chosen for copying. The next step is to choose which of the other tables the fields should be copied to.

Edit

The Edit option allows you to rename, change the types or the order of the columns in your tables. 

User-added image

All of these commands can work across multiple tables at once. For example, in the screen shot below a column has been selected across four tables to be renamed.

User-added image

And there is more...

  • Check out the option Display Object Column. This provides a facility to tell you if the table has objects, how many records contain an object and can even break down the different types of objects.
  • Text report - this is a handy summary about your tables.
User-added image
  • The columns in your tables can be displayed in terms of matching column names or in their native (original) order.
User-added image

Article by Tom Probert, Editor of "The MapInfo Professional" journal 

When not writing articles for "The MapInfo Professional", Tom enjoys talking to MapInfo Professional users at conferences and events. When not working he likes to see movies with car chases, explosions and kung-fu fighting.
 
UPDATED:  July 14, 2017