In the Open DBMS Table Options dialog, under Expert Mode, clicking the SQL View button opens the Enter SQL Query dialog box.
This dialog box lets you enter queries that are much more complex than what the wizard allows using the standard DBMS SQL syntax.
When entering queries:
- To get a new line press Enter.
- To tab press Ctrl+Tab.
- To cut and paste from the clipboard, press Ctrl+X to cut, Ctrl+C to copy, and Ctrl+V to paste.
- Click OK to move to the final dialog box of the wizard
- Click Cancel to cancel the query. MapInfo Pro returns you to the step in the wizard where you originally clicked the Expert button
- Click Load to load a SQL statement that has been saved in a file. This button activates the Load SQL Query dialog box, which provides you with access to existing files containing SQL statements (*.SQL files). When you load an SQL file, its format will be preserved.
- Click Save to save the SQL statement in a file for later use. This button activates the Save SQL Query dialog box, which saves the newly constructed SQL statements, or modifications to existing statements. When you save an SQL file, its format will be preserved. Once saved, the SQL statement appears in the list of available *.SQL files in the Load SQL Query dialog box.
- Click Last Query to load the last query that was executed in this MapInfo Pro session.