Create a table configuration file
The free 'DVD rental' sample database contains many tables, views, and functions related to the operation of fictional movie rental stores. This is the rental table for Navicat 17:
By default, tables will be displayed in the grid viewer, and records will be sorted according to the table design or the order in which they were added to the table. The columns will be presented in the order they appear from left to right in the table design.
Of course, we can change the presentation of the table in various ways. For example, we can:
·Application filtering and sorting
·Freeze certain columns in appropriate positions
·Hide columns
·Change column sorting
·Modify the width of the column
Let's try some operations on the rental table.
By changing the position of the column, we can drag it to any desired location. Similarly, we can change the width of the column by dragging its edges.
This is the rents_date column that has been dragged to the first position and resized to make it more compact:
We can also quickly sort the columns by clicking the arrow in the upper right corner of the column header and selecting an option from the pop-up menu:
Please note that the arrows now display the sorting order:
Save table configuration file
If we close the rental table now, all the changes we make will be lost the next time we access it. However, in Navicat 17, we can save them in a table configuration file. To do this, we will click the "Table Configuration File" button in the table toolbar, and then select the "Save Configuration File As" menu command (you can also click "Save Configuration File" because we have not saved the configuration file of the table yet):
A dialog box will pop up where we will name the configuration file. After customizing a descriptive name, we can click "OK" to create a new table configuration file:
Load table configuration file
As mentioned earlier, reopening the rental table will result in our changes being lost. Of course, after creating the table configuration file, we can access the table through "Table Configuration File" ->"Load Configuration File" ->"Configuration File Name" to restore the table to its previous state:
Return to default configuration file
If you want to return to the default configuration file, you can achieve it by selecting "Load Configuration File" ->"Default Configuration File" ->"Quick Mode":
Manage Profiles
Select "Table Profile" ->"Manage Profile" from the toolbar, and the profile window will pop up. Here, we can see which columns are hidden and which filters and sorting are applied, and it even displays a preview of the SQL used to retrieve the underlying data:
We can delete or load any configuration file by selecting it and clicking the 'delete' or 'load' button.
One final tip: We can open the directory containing the configuration file definition file on the device by right clicking on the configuration file (or holding down the Control key on the Mac) and selecting the "Open folder..." command from the pop-up menu:
With less than a week left until the release of Navicat 17 (English version), now is the best time to delve deeper into the new table configuration file functionality. It allows us to save different combinations of filtering, sorting, and column display commonly used for tables. So, it's not too late, let's get started!
Create a table configuration file
The free 'DVD rental' sample database contains many tables, views, and functions related to the operation of fictional movie rental stores. This is the rental table for Navicat 17:
By default, tables will be displayed in the grid viewer, and records will be sorted according to the table design or the order in which they were added to the table. The columns will be presented in the order they appear from left to right in the table design.
Of course, we can change the presentation of the table in various ways. For example, we can:
·Application filtering and sorting
·Freeze certain columns in appropriate positions
·Hide columns
·Change column sorting
·Modify the width of the column
Let's try some operations on the rental table.
By changing the position of the column, we can drag it to any desired location. Similarly, we can change the width of the column by dragging its edges.
This is the rents_date column that has been dragged to the first position and resized to make it more compact:
We can also quickly sort the columns by clicking the arrow in the upper right corner of the column header and selecting an option from the pop-up menu:
Please note that the arrows now display the sorting order:
Save table configuration file
If we close the rental table now, all the changes we make will be lost the next time we access it. However, in Navicat 17, we can save them in a table configuration file. To do this, we will click the "Table Configuration File" button in the table toolbar, and then select the "Save Configuration File As" menu command (you can also click "Save Configuration File" because we have not saved the configuration file of the table yet):
A dialog box will pop up where we will name the configuration file. After customizing a descriptive name, we can click "OK" to create a new table configuration file:
Load table configuration file
As mentioned earlier, reopening the rental table will result in our changes being lost. Of course, after creating the table configuration file, we can access the table through "Table Configuration File" ->"Load Configuration File" ->"Configuration File Name" to restore the table to its previous state:
Return to default configuration file
If you want to return to the default configuration file, you can achieve it by selecting "Load Configuration File" ->"Default Configuration File" ->"Quick Mode":
Manage Profiles
Select "Table Profile" ->"Manage Profile" from the toolbar, and the profile window will pop up. Here, we can see which columns are hidden and which filters and sorting are applied, and it even displays a preview of the SQL used to retrieve the underlying data:
We can delete or load any configuration file by selecting it and clicking the 'delete' or 'load' button.
One final tip: We can open the directory containing the configuration file definition file on the device by right clicking on the configuration file (or holding down the Control key on the Mac) and selecting the "Open folder..." command from the pop-up menu:
