Help:Octofy: Browser the database

From Sherlock Software
Revision as of 14:58, 6 October 2021 by Sherlock (talk | contribs)

The database object browser consists of two components: the object explorer and the search panel. They switch through the tab control.

Object explorer

Database object tree

The object explorer is a database object tree. It displays the available tables and views grouped by the schema and object type.

Search panel

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.
  • If it is a search column, the matching columns will be highlighted in the column view panel.

Search options

Search options dialog

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

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



Back to Octofy User Manual