Resolve Adding a Spatial Primary Key to a DBMS Table

Product affected: MapInfo Pro™
After establishing a data source connection to your DBMS you must add a geometry reference to the tables you wish to work with on a map in MapInfo Professional. Each table that you want to work with must contain geometry, such as regions, or X,Y point data, with correctly named columns and a unique primary key column that is indexed and defined with a specific name.
If you attempt to work with a DBMS table that does not contain a spatial primary key column and does not have geometry and X,Y columns correctly labeled, then you may see the following error: Unable to download only the OBJECT from a DBMS table. Select an additional attribute column.
To have MapInfo Professional prepare a table for you:
1. Open the table in MapInfo Professional, select File > Open and then locate and select the table from the Open dialog box.
2. Select File > Save Copy As and save a copy back to the DBMS.
This saves a copy of the table with a unique primary key column that is indexed and in the correct format. This process also asks you for your spatial geometry column or your X,Y columns in the table and then renames these columns, so that MapInfo Professional can work with them.
You are now ready to begin working with the data in MapInfo Professional in tabular form (in a Browser window). For details on what changes are made to column names, see the help file topic: Adding a Spatial Primary Key Manually.
If you want to convert your table to the MapInfo Professional native .TAB format to work with it, then use EasyLoader, which will also rename your geometry or point columns and add a spatial primary key column to the table.
UPDATED:  September 6, 2017