Help:Octofy: Browser the database
From Sherlock Software
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