Creating a New DBMS Table - MapInfo_Pro - 2023

1. On the TABLE tab, in the Content group, click New Table.
2. In the New Table dialog box:
   1. Specify how you want the table opened: Browser, Mapper, or Current Mapper.
   2. Specify whether you want the table structure to be based on an existing table or you want MapInfo Pro to create a new table structure.
   3. Click Create.
3. In the New Table Structure dialog box specify the field name, field type, number of characters (width), and whether or not to index for each field in your new database. Click Create.

   If you are using the structure from another mappable table, then MapInfo Pro sets the new table projection to the projection of the source table. Collectively, this information is the structure of your database.

   Note: You indicate whether the table is mappable by associating graphic objects with records and, if so, whether the map is to be an earth or a non-earth map.
4. In the Create New Table dialog box, from the Save as type drop-down list, select a DBMS type. The dialog box displays DBMS connection controls.

   In the File name box, type a file name and click Save.

Depending on the database type that you selected, the new table opens in MapInfo Pro or the New DBMS Table Options dialog box opens. If you see the New DBMS Table Options dialog box then continue to the next section.

Setting New DBMS Table Options

To set new DBMS table options, follow the instructions under Creating a New DBMS Table. Depending on the database type that you select, the New DBMS Table Options dialog box opens. This dialog box has three tabs, General, Spatial, and Styles. Refer to the following sections for information about each tab of options.

If you cleared the Make Table Mappable check box in Create New Table dialog box, then the DBMS Table Options dialog box shows only the General tab.

General Tab

Under the General tab complete the appropriate selections:

• TAB file location - Displays the name and path of the .TAB file that will be created. You can manually type a filename or use the Save As dialog box (via Browse button) to choose a filename. MapInfo Pro uses the last directory where you saved a DBMS .TAB when constructing the default filename full path. If this directory does not exist, then the Remote Tables preference directory is used. The filename part of the default path is based on the name of the specified DBMS table name.
• Browse (...) button - Displays the Save As dialog box so the user can choose a .TAB filename. Initialized with the text in the .TAB filename edit box.
• Primary Key Column - Lets you specify a key column for the new table. Without a key column a DBMS table cannot be open as live access and can only be opened read only as Linked.

  If the Primary Key Column check box is selected, then the corresponding combo box is enabled. You can either choose a column that was specified in the New Table Structure dialog box or specify a new column by typing into the combo box's edit control.

  By default the Primary Key Column check box is selected and a new column is specified. The default name of the new column depends on the DBMS connection: MI_PRINX for Oracle Spatial, SW_MEMBER for all others.

• Download Data (Linked Table) - Select to establish a linked connection to this table.
• Live Access - Select to access this table with a live connection.
• Cache - Select to save the table to the local buffer and then read the table data from the buffer. Access time to data is faster but you are not working with the most current version. Refresh occurs when you zoom, pan, or select. Unselect to read the table directly from the data source, which is the current version.

  The Cache check box enables after selecting the Live Access option.

Spatial Tab

Click the Spatial tab and specify the index type and coordinate column selections:

• Index Type - This setting determines the type of spatial indexing used on the table. Types MapInfo (MICODE) and XY are always available. Server specific types may also be listed. The index type selection affects the state of the other three controls in this tab.
• Index Column - Specify the primary spatial index column from the list. This option is always available, except when the index type is XY.
• X Coordinate - Specify the X or longitude column in the database from the list. This is only available for MapInfo (MICODE) or XY types. You can either choose a float column that was specified in the New Table Structure dialog box or specify a new column by typing into the combo box's edit control.
• Y Coordinate - Specify the Y or latitude column in the database from the list. This is only available for MapInfo (MICODE) or XY types. You can either choose a float column that was specified in the New Table Structure dialog box or specify a new column by typing into the combo box's edit control.

Styles Tab

Click the Styles tab and complete the appropriate selections:

• Per Row Style - Check the Per Row Style check box to enable per row symbology. The style information for each object is maintained in a character column of the table. If unchecked, then the style of all objects in the table is determined by the default object styles maintained in the Map Catalog.

  If Per Row Style is checked, then the Style Column combo box is enabled. By default Per Row Style is checked and a new column named MI_STYLE is specified.

• Style Column - Select from the list a character column that was specified in the New Table Structure dialog box or a new column by typing into the combo box's edit control.
• Default Object Styles - The default object styles are used when Per Row Style is not turned on for a table, or the style info for a particular object does not exist (the style column for that row is empty). The default style information specified here is entered into the map catalog. The default symbol, line, and region settings within MapInfo Pro are used to initialize these controls.