Table Browser

Table Browser

Table Browser allows users to browse database structures such as table schema and data stored in it.
Locating the desired tables can be easily performed by the search and the filtering feature it provides.
The name of the selected table in its table list can be applied in the [Table name] property.

Launch Table Browser

Table Browser can be launched by clicking [Launch Table Browser].

Table Browser screen

The startup screen of Table Browser

When it is first started Table Browser looks as the figure below.


Numbering in the figure Name Description Remarks
(1) Table Selection pane Tables can be selected in this pane.  
(2) Filter string input field String to use for filtering the list of tables.
(3) Table list view List all tables
The table information pane will show details for the selected table in the table list.
  • The maximum number of tables listed is determined by Global Resource settings.
  • If there is a name specified in the [Enclose table name with quotation marks] property, table with that name is selected at startup.
  • When [Enclose table name with quotation marks]property is checked, table names are enclosed in quotation marks.
    Not applicable if the [Enclose table name with quotation marks] property does not exist.
(4) Table Information pane Displays the information on the selected table.  
(5) Table name Displays the name of table currently selected.
  • If there is a name specified in the [Table name] property, table with that name is selected at startup.
(6) Table information view Displays table structures, table data, and table related information  
(7) Table structure Tab Displays the structure of the selected table.
(8) Table contents Tab Displays the contents stored in the selected table.
(9) Table relation information Tab Provides table relation information such as columns with the foreign key reference.
(10) Select table When clicked, the name of the currently selected table is applied to the [Table name] property and window will be closed.
  • Not applicable when [Table name] property does not exists at startup.
(11) Help Activate Help to display the table browser page.  

Table structure

Displays the structure of the selected table.
Item name Description Remarks
Name Column name  
Type Displays type
  • Displays the RDBMS specific Native types
Allow null Displays whether Null is allowed.
  • [YES]:
    Null is allowed.
  • [NO]:
    Null is disallowed.
  
Size Displays the length.  
Precision Displays the precision.  
The number of decimal places Displays the number of decimal places.  

Table contents

Displays the contents stored in the selected table.
Item name Description Remarks
<Column name> Column name
  • The selected column of the table is displayed in the [<Column name>]
  • Total number of columns in the selected table is displayed.

Table relation information

Provides table relation information such as columns with the foreign key reference.
Item name Description Remarks
Reference source table Displays the table name of the currently selected table.  
Reference source column Displays the names of the columns with foreign key constrains  
Reference destination table Displays the name of the tables referencing the foreign key constraints that are show in the [Reference source column].  
Reference destination column Displays the column names of the [Reference destination table] referencing the foreign key constraints that are show in the [Reference source column].  

Table Selection pane for inputting a filter string

Below is the structure of Table Selection pane for inputting a filter string to [Enter a filter string].



Numbering in the figure Name Description Remarks
(1) Show information of "<string>"... Displays the table with the name of input string to Table Information pane.
  • Variables such as Environment Variables cannot be changed.
(2) Table list view Filters and displays the list of the table names including the input string.  
(3) Search tables by "<string>"... Search tables including the input string from a database.
  • After a search, Table Selection pane switches to the one for searching a table.
  • Wildcards of "%" (more than 0) and "_" (arbitrary 1 character) can be used.
  • Distinction of capital letters and small letters relies on the database.
  • Escape is required when using wildcard letters such as "%" and "_" as a search string. How to specify Escape relies on the database.
  • Variables such as Environment Variables cannot be used.

Table Selection pane for searching tables

Below is the structure of Table Selection pane when clicking the [Search tables by "<string>"] link.



Numbering in the figure Name Description Remarks
(1) Table list view Displays the list of results by searching table names including the searched strings.  
(2) Back to table list... Go back to the table listed shown when started.  

Browse table information

Tables can be browsed in the following procedure.
  1. Select a table from the table list view.
    To have the tables listed filtered with a search string, see Filtering table names for the instructions.
    To search the table name from the database, see "Search table name".
    To type in a string to display a table, see "Display table directly".

  2. Table information view displays the information on the selected table.

  3. If the [Select table] button is shown, clicking the button will apply the name of the selected table to the [Table name] property.

Filtering table names

If many tables are displayed in the list and hard to find the right one, you can filter table names to narrow down the results.
The procedure is as follows.
  1. Enter a filter string in the [Filter string input field].

  2. The table names are filtered by the search string and displayed in the corresponding table list view.

Searching table name

If the target table does not exist in the tables specified in the global resource, you can search the table from the database and display the list of results in Table List View.
The procedure is as follows.
  1. Enter a search string to [Enter a filter string].

  2. Click the [Search tables by "<string>"] link.

  3. Search the list of table names including input strings. The result is displayed in Table List View.

  4. To display the list of the table before searching, click the [Back to table list] link.

Displaying the table

If you know the target table name, you can directly type in the table name and display information in Table Information View.
The procedure is as follows.
  1. Enter a table name to [Enter a filter string].

  2. Click the [Show information of "<string>"] link.

  3. Table information on the table name entered in Table Information View is displayed.
    An error will occur if the specified table name does not exist.

Specification Limits

Main exceptions

None