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 / Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later Oracle • Amazon RDS for SQL Server • Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud

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 / Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later Oracle • Amazon RDS for SQL Server • Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud

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 / Percona Server • PostgreSQL 7.3 or later • Oracle 8i or later • SQLite 2 and 3 5 • SQL Server 2000 or later • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later Oracle • Amazon RDS for SQL Server • Amazon RDS for MariaDB Google Cloud • Google Cloud SQL for MySQL • Google Cloud SQL for PostgreSQL • Google Cloud SQL for SQL Server Oracle Cloud

Types 67 Foreign Servers 68 Other Objects 68 Maintain Objects 68 Manage Extensions 69 SQL Server 69 Databases & Schemas 69 Tables 70 Views 71 Procedures / Functions 71 Other 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 Oracle Query (Available only Query Results 122 MongoDB 123 Query Editor 123 Find Builder (Available only in Non-Essentials Edition) 126 Aggregate Builder (Available only in Non-Essentials Edition) 127 Query Results

Types 66 Foreign Servers 66 Other Objects 67 Maintain Objects 67 Manage Extensions 67 SQL Server 68 Databases & Schemas 68 Tables 68 Views 69 Procedures / Functions 70 Other 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 Oracle Query (Available only Query Results 120 MongoDB 121 Query Editor 121 Find Builder (Available only in Non-Essentials Edition) 125 Aggregate Builder (Available only in Non-Essentials Edition) 126 Query Results

Types 66 Foreign Servers 66 Other Objects 66 Maintain Objects 67 Manage Extensions 67 SQL Server 68 Databases & Schemas 68 Tables 68 Views 69 Procedures / Functions 70 Other 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 Oracle Query (Available only Query Results 119 MongoDB 120 Query Editor 120 Find Builder (Available only in Non-Essentials Edition) 124 Aggregate Builder (Available only in Non-Essentials Edition) 125 Query Results

the SOFTWARE or remove it from his system. The UNREGISTERED SOFTWARE may be freely copied and distributed to other users for their evaluation. f. "Navicat Essentials" means a version of the Software of the primary computer on which the Software is installed. c. In the event the Software is distributed along with other PremiumSoft software products as part of a suite of products (collectively, based upon the Software. f. Non-commercial Versions of the Software may not be used for, or distributed to any party for, any commercial purpose. g. Unless otherwise provided herein, you shall not

Non-Essentials Version) 63 Forward Engineer Physical Model 63 Synchronize to Database 63 Export SQL 68 Chapter 12 - Other Advanced Tools 70 Useful Features 70 Model Conversion 70 Auto Layout models. It enables users to design database structures, reverse engineer, forward engineer, generate SQL files and print models to files, etc. Navicat Data Modeler is available on three platforms - Microsoft cal models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud, Microsoft Azure)

Non-Essentials Version) 65 Forward Engineer Physical Model 65 Synchronize to Database 65 Export SQL 69 Chapter 12 - Other Advanced Tools 71 Useful Features 71 Model Conversion 71 Auto Layout models. It enables users to design database structures, reverse engineer, forward engineer, generate SQL files and print models to files, etc. Navicat Data Modeler is available on three platforms - Microsoft cal models. • Support various database systems: MySQL, MariaDB, Oracle, PostgreSQL, SQLite and SQL Server (including cloud databases like Amazon RDS, Amazon Redshift, Alibaba Cloud, Microsoft Azure)

SOFTWARE or remove it from his system. The UNREGISTERED SOFTWARE may be freely copied and distributed to other users for their evaluation. f. "Navicat Essentials" means a version of the Software of the primary computer on which the Software is installed. c. In the event the Software is distributed along with other PremiumSoft software products as part of a suite of products (collectively, based upon the Software. f. Non-commercial Versions of the Software may not be used for, or distributed to any party for, any commercial purpose. g. Unless otherwise provided herein, you shall not