Option Description. Range Type - Fixed Range Type - Custom
Option Description. Database Create data source using existing connections in Navicat Cloud or On-Prem Server, or create a new connection in the workspace. For more information about connection settings, see Connect to Database Server. File/ODBC Import data to the workspace, or link the data source to the data in a supported external file or ODBC source. For more information about import steps, see Import Data from File/ODBC. Recent Connections Choose the connections used in other existing data sources in the workspace.
Option Description. On-Prem Server Name Enter the name to describe your On-Prem Server. Host The host name or IP address of your On-Prem Server. Port The port number of your On-Prem Server. Verify Server Certificate Enable this option to verify the server certificates. Enable Push Synchronization Navicat receives a silent push notification whenever its files stored in your On-Prem Server changes.
Option Description. Design Foreign Key Edit the foreign key in a table designer. The options in the designer depend on the diagram database type you are chosen. Go to Go to and select the connected table/collection. Reroute Connectors Reroute the connector to the closest points between two connected objects. Copy Copy the foreign key from the diagram to the clipboard. Paste Paste the content from the clipboard into the diagram. Save as Image Save the foreign key as a PNG file. Select All Connected Objects Select all objects in the diagram that are connected by the foreign key. Select All Relations Select all foreign keys in the diagram. Delete from Diagram and Model Delete a foreign key from both diagram and model. Color Change the color of the foreign key. Group / Ungroup Group or ungroup the foreign key and other objects in the diagram. Lock / Unlock Lock or unlock the foreign key in the diagram. Once you have selected the foreign key, you can customize the foreign key by changing its properties: Name Enter the name of the foreign key. Position Customize the position of the line. Offset Customize offset values for the start and end of the line. Show name Display the name of the foreign key. Font Set the font style of the name. Bold Apply a bold style to the name. Italic Apply an italic style to the name. Color Set the color of the line. Line Width Choose the thickness of the line. Cardinality Specify the relationship cardinality of the table/collection. Visible Show the connector. Group / Ungroup Group or ungroup the foreign key and other objects in the diagram. Lock / Unlock Lock or unlock the foreign key in the diagram. Add Views 1. Click the button from the toolbar.
Option Description. Highlight All Highlight all matches in the editor. Incremental Search Find matched text for the search string as each character is typed. Match Case Enable case sensitive search. Regular Expression Search regular expressions. Whole Word Return the objects that match the entire word of the search string. Click the Replace All button to replace all occurrences automatically. There are some additional options for Find and Replace, click : Navicat Data Modeler has the ability to zoom in or zoom out the SQL in the editor. Zoom In: [CTRL++] or [CTRL+Mousewheel Up] Zoom out: [CTRL+-] or [CTRL+Mousewheel Down] Reset: [CTRL+0] View Builder (Available only in Enterprise Edition) 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 familiar with SQL, the convenient and fluent graphical interface makes it easier to create relations and visualize the view. In View Designer, click the View Builder button to open the visual View Builder. All database objects are displayed on the left Object pane. Whereas on the middle 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. The first step is to decide which tables and views you need to add to the view. To add tables and views to the view, use one of the following methods: • Drag them from the Object pane to the Diagram pane. • Double-click them on the Object pane. You can set aliases for tables, views and subqueries by double-clicking the object title on the Diagram pane and entering the name to use as an alias for the object name. After you have added objects to the diagram, you can use the FROM tab to adjust the view to your needs. • To change the object, click the object and select an identifier. • To add the table alias, click <Alias>. You can right-click an object on the Diagram pane and select Remove, or simply press DELETE key to remove the selected object from the view. When you remove an object, View Builder automatically removes joins that involve that object. To include fields in the view, use one of the following methods: • Check the left checkbox of a field name you want to add to the view on the Diagram pane. • To include all the fields for an object, check the * checkbox on the Diagram pane. • To add all fields for all objects, click on the SELECT tab and select All field...
Option Description. Allow Users can connect to the database. Disallow No users can connect to the database. Analyze Database Collect statistics about the database. Vacuum Database Garbage-collect and optionally analyze the database. Reindex Database Recreate all indexes within the database.
Option Description. Analyze Database Collect statistics about the database. Vacuum Database Rebuild the database file. It only works on the main database. Reindex Database Delete and recreate all indexes within the database.
Option Description. Enable Row Movement Allow the database to move a row, thus changing the rowid. Disable Row Movement Prevent the database from moving a row, thus preventing a change of rowid. Shrink Space Compact the materialized view log segments. Compile Recompile the package specification and body. Compile for Debug Recompile the package specification and body. Instruct the PL/SQL compiler to generate and store the code for use by the debugger.
Option Description. Analyze Tables Collect statistics about the contents of the table. Reindex Tables Delete and recreate all indexes of the table. Get Rows Count Count the number of rows in the table. Reindex Delete and recreate the index. MongoDB Databases To start working with the server objects, you should create and open a connection. If the server is empty, you need to create a new database.
Option Description. Enable Enable the trigger. Disable Disable the trigger. Compile Recompile the trigger. Compile for Debug Recompile the trigger. Instruct the PL/SQL compiler to generate and store the code for use by the debugger. Compile Recompile the type specification and body. Compile for Debug Recompile the type specification and body. Instruct the PL/SQL compiler to generate and store the code for use by the debugger. Compile Recompile the already registered XML schema. Purge Removes the XML schema completely from Oracle XML DB. Read Only Place the tablespace in transition read-only mode. Read Write Allow write operations on a previously read-only tablespace. Online Take the tablespace online. Offline Take the tablespace offline. Coalesce Combine all contiguous free extents into larger contiguous extents for each datafile in the tablespace. Shrink Space Reduce the amount of space the tablespace is taking. PostgreSQL Databases & Schemas To start working with the server objects, you should create and open a connection. If the server is empty, you need to create a new database and/or a new schema.
