How to create a simple query to expose all object types in a table in MapInfo Professional
UPDATED: August 9, 2017
With a mappable table open in MapInfo Pro, users can return a simple list of all the various object types in the table, such as point, region, ellipse, etc.
With the table open in MapInfo Professional, choose Query>SQL Select and load the table from the "Tables" drop-down. Choose the "Select Columns" section and delete the asterisk(*) and replace with the word obj.
In the "Group by" and "Order by" Columns section, enter 1 and run the query:
Users can also easily get the count of each object type by adding the "Count" variable from the Aggregates drop-down
to the Select Columns section:
- No Downloads