Search

The search is the main part of the tool.

To search for something enter the desired phrase and hit Enter or the Search button.

The result of the search will be shown below the search box. If you select an entry the content of the entry will be shown below. If you select a table, the preview shows the columns (with some additonal information) of the table:

Here a short explanation of the columns:

Column	Description
Pos.	The position / order of the column in the table
Name	The name of the column (obviously)
Type	The data type of the column
Max. Length	The max. length of the column.
Precision	The precision of the column (for example how many decimal places). The value will be 0, 0 for columns without a precision.
PK	Indicates if the columns is a part of the primary key
Index / FK	Indicates if the column is included in an index or is used for a foreign key
Identity	Indicates if the column is an identity column (auto increment for MySql users 😎)
Null	Indicates if the column allows null values
Computed	Indicates if the content of the column is computed
Replicated	Indicates if the column is used in a replication
Default	The default value of the column

In addition to the columns, you can also view the definition of a table. To do this, select the "Definition" tab.

Importand: Loading the definition may take longer depending on the server!

If you select a procedure, view, trigger, ... the preview shows the definition of the entry:

Options

• Show indexes (only available if a table with an index is selected): Shows a dialog with all index values of the table (e.G. primary key, foreign key)
• Open query window: Displays a window in which you can view the contents of a table
• Copy / Export: Copies, exports the preview of the table / table type (table preview)
• Copy: Copies the content of the preview (SQL preview)
• History: Shows you search history (you can also hit CTRL + F while your cursor stays in the search box)
• Open in class generator...: Opens the selected table / table type in the class generator. This function is also available via the context menu of the search result grid. Note: This option is only available when you have selected a table / table type.

Open query window

You can use the window to view the contents of a table.

To keep the data volume low, it is advisable to set the limit as low as possible (1,000 entries is standard).

You also have the option of exporting the contents of the table here.