Difference between revisions of "Help:Octofy: Browser the database"
From Sherlock Software
m |
m (→Search panel) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 6: | Line 6: | ||
==Search panel== | ==Search panel== | ||
[[File:Octofy_Search.png|250px|thumb|right|Database object search panel]] | [[File:Octofy_Search.png|250px|thumb|right|Database object search panel]] | ||
* The database object search panel provides a quick way to locate database objects. It can quickly list matching database objects by searching the names of data tables, views, or columns. | * The database object search panel provides a quick way to locate database objects. It can quickly list matching database objects by searching the names of data tables, views, or columns. | ||
* The Octofy supports to search database objects within a specific schema. To search for database objects in a specific schema, enter the name of the schema, followed by a period and the search content. | |||
* If it is a search column, the matching columns will be highlighted in the column view panel. | * If it is a search column, the matching columns will be highlighted in the column view panel. | ||
==Search options== | ===Search options=== | ||
[[File:Octofy_search_options_dialog.png|250px|thumb|right|Search options dialog]] | [[File:Octofy_search_options_dialog.png|250px|thumb|right|Search options dialog]] | ||
Database object search also provides the following search matching methods: | Database object search also provides the following search matching methods: | ||
| Line 16: | Line 17: | ||
* Contains the search text | * Contains the search text | ||
* Exactly matches the search text | * Exactly matches the search text | ||
You can change the search matching method through the Search Options dialog box. | |||
==Column list view== | |||
[[File:Octofy_Column_view.png|250px|thumb|right|Column view]] | |||
The column view is a data grid. It lists the following information about the selected database object: | |||
* Column name | |||
* Data type and length | |||
* Sequence number in the database object | |||
* Whether the column value can be null | |||
</br> | </br> | ||
Latest revision as of 21:17, 28 October 2021
The database object browser consists of two components: the object explorer and the search panel. They switch through the tab control.
Object explorer
The object explorer is a database object tree. It displays the available tables and views grouped by the schema and object type.
Search panel
- The database object search panel provides a quick way to locate database objects. It can quickly list matching database objects by searching the names of data tables, views, or columns.
- The Octofy supports to search database objects within a specific schema. To search for database objects in a specific schema, enter the name of the schema, followed by a period and the search content.
- If it is a search column, the matching columns will be highlighted in the column view panel.
Search options
Database object search also provides the following search matching methods:
- Start with the search text
- End with the search text
- Contains the search text
- Exactly matches the search text
You can change the search matching method through the Search Options dialog box.
Column list view
The column view is a data grid. It lists the following information about the selected database object:
- Column name
- Data type and length
- Sequence number in the database object
- Whether the column value can be null
Back to Octofy User Manual
