1. Connect (if necessary) to an HFSQL server. For more details, see Managing HFSQL Client/Server databases.
2. Select the name of the HFSQL server in the tree structure.
3. Select the name of the desired database.
4. Double-click the name of the desired data file.
5. The right section of Control Center displays a tab with the name of the data file. This tab includes:
   • several tabs used to manage the characteristics of the HFSQL data file. The "Content" tab is displayed by default.
   • a ribbon used to configure the HFSQL data file.

Note From the Control Center pane, the data file context menu allows you to:

• Optimize and repair the data file. For more details, see Optimizing and repairing data files.
• Close the data file.
• Change the password of the data file.
• Delete the data file.
• Manage the rights on the database.

"Description" and "Properties" tabs

• The item name,
• The type of the item,
• The size of the item,
• The type of key,
• Whether the item is visible in "Reports & Queries".

"Connections" tab

• the username,
• the computer name,
• the name of the application accessing the file, etc.

• New in version 2025
  Filter connections by machine, user and/or connection.
• Disconnect users.
  
  New in version 2025
  Simply select the user(s) to be disconnected from the list of connections, then use the "Disconnect selected users" option in the ribbon.
• Send a message to the users.
  
  New in version 2025
  Simply select the recipient user(s) from the list of connections, then use the "Send a message to the selected users" option in the ribbon.

"Locks" tab

• the number of the locked record,
• the name of the user who is locking,
• the name of the locking computer,
• the IP address of the locking computer,
• the name of the locking application,
• the lock start date,
• the lock duration.

"Content" tab

You can also filter the records displayed using the bar above the table.

The filter context menu () offers several options:

• Automatic application: the filter is automatically executed when it is validated by pressing the Enter key on the keyboard. If this option is not selected, you must apply the filter by clicking the green check mark on the right of the filter bar.
• Delete current filter: Clears the filter field.
• Copy SQL code: Copies the SQL code corresponding to the filter entered to the clipboard.
• Create a query: displays the "Query" pane with the SQL code of the query entered (equivalent to the "New query" ribbon option).
• Empty filter history: filters created are automatically saved for rapid re-application. You can clear the filter history.

• view the record details (select the "View record" option or double-click the row). A window opens allowing you to view and edit the item values. You can use the navigation buttons to quickly view other records in the same window.
• manipulate the selected record: delete, add, modify, etc.. The data file is automatically updated. Note: Editing and adding recordings is carried out in the View window.
• configure the display options.
• filter the current column.
• print the record.
• etc.

"Logs" tab

"Transactions" tab

Ribbon details

• In the "SQL query" group:
  • New query: This option opens a special tab for SQL queries on the current database..
  • Open a query: This option opens a specific tab corresponding to a previously performed query..
  For more details, see Creating and executing a query.
• In the "File" group:
  • Optimize and repair: This option opens the data file optimization configuration window.. For more details, see Optimizing and repairing data files.
  • Close file: this option closes the data file and the corresponding tab..
• In the "Rights" group, the "Manage rights" option allows you to manage the rights granted to the users and groups on the data file.