Difference between revisions of "Help:Octofy: Browser the database"
From Sherlock Software
m |
m (→Search panel) |
||
| 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. | ||
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
