Editors 105 Filter Wizard 106 Chapter 7 - Query 109 About Query 109 RDBMS 110 Query Editor 110 Query Builder (Available only in Non-Essentials Edition) 114 Query Parameters 120 Debug Query Editor 121 Find Builder (Available only in Non-Essentials Edition) 125 Aggregate Builder (Available only in Non-Essentials Edition) 126 Query Results 126 Redis 127 Query Editor 127 General 307 Tabs 308 Code Completion (Available only in Non-Essentials Edition) 309 Editor 309 Records 310 Auto Recovery 312 Connectivity 312 Environment 313 Advanced 314

Editors 107 Filter Wizard 108 Chapter 7 - Query 111 About Query 111 RDBMS 112 Query Editor 112 Query Builder (Available only in Non-Essentials Edition) 116 Query Parameters 122 Debug Query Editor 123 Find Builder (Available only in Non-Essentials Edition) 126 Aggregate Builder (Available only in Non-Essentials Edition) 127 Query Results 128 Redis 128 Query Editor 128 General 308 Tabs 309 Code Completion (Available only in Non-Essentials Edition) 310 Editor 310 Records 311 Auto Recovery 313 File Locations 313 Connectivity 315 Environment

Editors 104 Filter Wizard 105 Chapter 7 - Query 108 About Query 108 RDBMS 109 Query Editor 109 Query Builder (Available only in Non-Essentials Edition) 113 Query Parameters 119 Debug Query Editor 120 Find Builder (Available only in Non-Essentials Edition) 124 Aggregate Builder (Available only in Non-Essentials Edition) 125 Query Results 125 Redis 126 Query Editor 126 General 311 10 Tabs 312 Code Completion (Available only in Non-Essentials Edition) 313 Editor 313 Records 314 Auto Recovery 315 Environment 315 Advanced 317 Chapter 19 - Hot Keys

Table 42 Adjust Field Structures 42 Preview Data 42 Start Import 43 Add Query 43 Query Editor 43 Query Builder 46 Modify Data Source Connections 52 View Data 53 Filter / Sort / Project Chapter 9 - Configurations 105 Options Settings 105 General 105 Code Completion 105 Editor 106 Records 107 Auto Recovery 107 File Locations 107 Connectivity 108 Environment On the Connections pane, double-click New Data Source Query. 2. Write the statement in Query Editor. You can also use Query Builder to build the query visually. 3. Click Save Query. 4. Enter the

Table 40 Adjust Field Structures 40 Preview Data 40 Start Import 41 Add Query 41 Query Editor 41 Query Builder 45 Modify Data Source Connections 50 View Data 51 Filter / Sort / Project Chapter 9 - Configurations 103 Options Settings 103 General 103 Code Completion 104 Editor 104 Records 105 Auto Recovery 105 Connectivity 105 Environment 106 Advanced 107 On the Connections pane, double-click New Data Source Query. 2. Write the statement in Query Editor. You can also use Query Builder to build the query visually. 3. Click Save Query. 4. Enter the

Table 40 Adjust Field Structures 41 Preview Data 41 Start Import 42 Add Query 42 Query Editor 42 Query Builder 45 Modify Data Source Connections 51 View Data 52 Filter / Sort / Project Chapter 9 - Configurations 104 Preferences / Settings 104 General 104 Code Completion 104 Editor 105 Records 106 Auto Recovery 106 File Locations 106 Environment 107 Advanced 108 On the Connections pane, double-click New Data Source Query. 2. Write the statement in Query Editor. You can also use Query Builder to build the query visually. 3. Click Save Query. 4. Enter the

Mode 73 Chapter 13 - Configurations 74 Preferences / Settings 74 General 74 Tabs 74 Editor 75 Code Completion (Available only in Non-Essentials Edition) 76 Auto Recovery 76 Models Designer, you can build the views visually using View Builder or edit the view definition in SQL Editor directly. Note: The tabs and options in the designer depend on the diagram database type and version enable Show Current Layer Only to show the subquery SQL. Edit View's Definition In the SQL Editor tab, you can create and edit the SELECT statement SQL for a view. Navicat Data Modeler provides

76 General 76 Code Completion (Available only in Non-Essentials Edition) 76 Model 77 Editor 77 Auto Recovery 78 File Locations 78 Connectivity 79 Environment 79 3 Advanced feature in Navicat Data Modeler pops up a list of suggestions as you type your SQL statement in the editor. It assists you with statement completion and the available properties of database objects, for example feature in Options. Clipboard Stack 38 When you copy or cut some codes as usual in the editor, the copied content will also be added to Clipboard Stack. Clipboard Stack can store up to 10 items