SQLite 2 and 3 5 • SQL Server 2000 or later • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported tables on different server types. The fields in the dataset can be used to construct a chart. When building a chart, you will need to specify the data source that the chart uses. Connections Pane during the data source creation, and stored the retrieved data in the workspace for later use by building charts. Preview Pane The Preview pane displays the data of the data source. 29 Properties

SQLite 2 and 3 5 • SQL Server 2000 or later • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported tables on different server types. The fields in the dataset can be used to construct a chart. When building a chart, you will need to specify the data source that the chart uses. Connections Pane during the data source creation, and stored the retrieved data in the workspace for later use by building charts. Preview Pane The Preview pane displays the data of the data source. Properties Pane

SQLite 2 and 3 5 • SQL Server 2000 or later • MariaDB 5.1 or later • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported tables on different server types. The fields in the dataset can be used to construct a chart. When building a chart, you will need to specify the data source that the chart uses. Connections Pane during the data source creation, and stored the retrieved data in the workspace for later use by building charts. Preview Pane The Preview pane displays the data of the data source. 28 Properties

0, 11.0, 12.0, 13.0, 14.0, 15.0 • SQLite 3 • Redshift 1.0 • GaussDB 3.2 • OceanBase Community and Enterprise 3.2 (Enterprise Oracle Mode is not available in macOS Edition) Installation We in Non-Essentials Version) Navicat Data Modeler provides a useful tool called View Builder for building views visually. It allows you to create and edit views without knowledge of SQL. Even if you are pane, it is divided into two portions: the upper Diagram pane, and the lower Criteria pane. When building the view, you can view the auto-generated SQL on the right SQL pane. Add Objects to View

4, 9.5, 9.6, 10.0, 11.0, 12.0, 13.0, 14.0, 15.0 • SQLite 3 • Redshift 1.0 • OceanBase Community and Enterprise 3.2 (Enterprise Oracle Mode is not available in macOS Edition) Installation We in Non-Essentials Version) Navicat Data Modeler provides a useful tool called View Builder for building views visually. It allows you to create and edit views without knowledge of SQL. Even if you are pane, it is divided into two portions: the upper Diagram pane, and the lower Criteria pane. When building the view, you can view the auto-generated SQL on the right SQL pane. Add Objects to View

later 12 • MongoDB 3.0 or later • Redis 2.8 or later, Redis Cluster • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported records by the current value in the cell.  The Custom Filter dialog is provided for quick building a simple filter. Just simply right-click the grid and select Filter -> Custom Filter from the by the current value of the selected field.  The Custom Filter dialog is provided for quick building a simple filter. Just simply right-click the grid and select Filter -> Custom Filter from the

later 12 • MongoDB 3.0 or later • Redis 2.8 or later, Redis Cluster • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported by the current value in the cell. 89  The Custom Filter dialog is provided for quick building a simple filter. Just simply right-click the grid and select Filter -> Custom Filter from the by the current value of the selected field.  The Custom Filter dialog is provided for quick building a simple filter. Just simply right-click the grid and select Filter -> Custom Filter from the

later 12 • MongoDB 3.0 or later • Redis 2.8 or later, Redis Cluster • OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode is not available in macOS Edition) Supported for editing the query text directly, and Query Builder, Find Builder or Aggregate Builder for building queries visually. You can save your queries for setting automation tasks. In the main window, Description MySQL, Oracle, PostgreSQL, SQLite, SQL Server and MariaDB Open the Query Builder for building queries visually. Format the codes with the Beautify SQL settings in Editor. Create a new