In the Select One or More Table to Open dialog box, you can select the tables to open from a data source. The tables you select open with the options that you set in this dialog box; you can customize tables by picking column or row filters or to set a default display styles. When opening tables from a SQLite database that has no Map Catalog, setting the display style ensures that the table always opens with an appropriate style.
To access the Select One or More Tables to Open dialog box, on the HOME tab, in the File group, on the Open list, click Table. From the Files of type list, select SQLite Database (*.sqlite). Select a SQLite database from the list of files and click Open. The dialog box can also be accessed by selecting GeoPackage (*.gpkg) from the Files of type list.
When opening a GeoPackage, not all of the dialog options below display. Instead of Database and Schema for example, the dialog shows the file path of the selected GeoPackage (.gpkg) file. GeoPackage files are very similar to SQLite files in that they exist as single files (in this case .gpkg as opposed to .sqlite) that can contain a number of tables.
Available tables from the data source display in a list panel. The names of the tables correspond to the names within the data source or GeoPackage file. Each table defines a set of objects, such as lines, symbols and regions. When you customize a table by changing its style or tab file location, an shown astrix (*) is shown beside its name. Its status is also shown in the text below the table list.
Database
Shows the name of the database for the connection that you selected in the Open dialog box.
Schema
Select a schema (owner) to display tables for. The Schema list only displays when the connection supports multiple schemas (owners).
Database Tables
Style
Opens the Change Table Object Style dialog box where you can specify the display style for geometry (spatial object types), such as symbols, lines, and regions in the table. Changes apply to the current table selected in the table list. Style changes define the default style of objects that open in MapInfo Pro.
Options
For a database connection, this opens the Open DBMS Table Options dialog box where you can apply column and row filters on the table. Filters let you choose which columns and rows to fetch from the data source. You would do this to reduce the amount of information that you will work with and reduce the time it takes to fetch and save the data.
For a GeoPackage, this opens the Options dialog box where you would change the TAB file location for a highlighted table in the table list.
Select All
Select all the tables in the table list.
Clear
Cancel all table selections from the table list.
Filter Tables
Select which types of tables appear in the table list.
Common Options
The common options apply to all selected tables, unless a table has been customized to use different options.
Linked
Select to use as a linked table. A linked table is a special kind of MapInfo table that is downloaded from a remote database and retains connections to its remote database table. You can perform most operations on a linked table that you do for a regular MapInfo table.
Live
Select to access the table directly from its source location.
Cached
This option enables after selecting the Live option. 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.
Clear to read the table directly from the data source, which is the current version.
Read Only
Opens the table in read-only mode. You are unable to edit the table and you cannot save the table back to the database or GeoPackage.
Folder
This option enables after selecting the Linked option and when opening tables from a GeoPackage. Select to save the table to a specific location on your machine. Selecting this opens the Browse for Folder dialog box, where you can select a folder to save the file to. This becomes the default location.
Preferred View
MapInfo Pro displays your data in a window based on your selection. MapInfo Pro remembers your selection and uses it for every subsequent selection until you change it.
- Automatic - MapInfo Pro chooses the most appropriate view. If the data is mappable, such as when graphic objects are attached to the data, MapInfo Pro opens the table in a Map window. If you have a Map window displayed and the table you want to open is mappable, MapInfo Pro automatically opens the table in the current Map window. If the data is not mappable, MapInfo Pro will attempt to open the table in a Browser window. If the table cannot be mapped or browsed, MapInfo Pro opens the table using the No View option (no data is displayed).
- Browser - MapInfo Pro attempts to open the table in a Browser window.
- Current Mapper - MapInfo Pro attempts to add your data to the current Map window.
- New Mapper - MapInfo Pro attempts to open the table in a new Map window.
- No View - MapInfo Pro opens the table making the data available for other uses, but no data is displayed. You will see it in the Tables list in the Explorer window.
OK
Accept dialog box options.
Cancel
Cancels selections and closes the dialog box.