Difference between revisions of "Help:Octofy: Browser the database"

From Sherlock Software
m
m
Line 17: Line 17:
* Exactly matches the search text
* Exactly matches the search text
You can change the search matching method through the Search Options dialog box.
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>

Revision as of 14:58, 6 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

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