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.
User-added image

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:
User-added image

User-added image

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:
User-added image

Environment Details



  • No Downloads