Shulou(Shulou.com)06/01 Report--

This article will explain in detail how to set advanced database properties for navicat. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article.

Navicat is a set of fast and reliable database management tools. Advanced database properties can also be set in the setting advanced connection tab. Whether or not to set advanced database properties is not mandatory. If you need to set up an advanced database, only if you check "use Advanced connection". The details are as follows:

MySQL, PostgreSQL, and MariaDB advanced database properties

The selected database in the connection tree is in the closed state. Click the database in the database list.

The selected database in the connection tree is in the Open state. Double-click the database in the database list.

Add a hidden database

1. Click the add Database to list button.

two。 Enter the name of the database.

3. Select the newly added database in the list of databases.

Remove a database: select the database you want to remove from the database list and click the remove Database from list button. It is important to note that the database is only removed from the database list, not from the server, and it still exists on the server.

Advanced database properties of SQLite

Click the "attach Database" button to attach a database file.

Database file: sets the file path of the database.

Database name: enter the database name displayed by "Navicat".

Encrypted: enable this option and provide a password to connect to the encrypted SQLite database.

Detach a database: select it from the list and click the "detach database" button.

About navicat how to set advanced database properties to share here, I hope the above content can be of some help to you, you can learn more knowledge. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.