Pitney Bowes MapInfo Professional - Manual (Page 188)

If you are using the structure from another mappable table, then MapInfo Professional sets the new
table projection to the projection of the source table. Collectively, this information is the structure of
your database.
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. Note:
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 Professional 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
Professional 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.
MapInfo Professional 12.5 188
Opening a DBMS Table in MapInfo Professional