Table Editor Preferences

Table Editor

Option
Description
Default
Insert default values
If this option is turned on, then if you start the insertion of a new row (Insert key) the values of the added row will be prefilled with the default values of the database table columns. If  there is no default value defined, then one of the following action is chosen:
  • if the column is nullable, then SQL NULL is the default
  • if the column is not nullable and not unique, the default is '0' , or 0 for numeric data types
  • if the column is unique, then the default is chosen from a distinct select over this column, while the greatest value from the result  is  added to 1 for numeric data types respectively the last character is added to 1 for character data types.
Off
Automatically refresh complete editor on update
If this option is turned on, after an insert, update or delete operation the editor is refreshed. Reasons to turn off this option could be very large tables or slow connections.
Tip: A better alternative for large tables is to apply a filter. That speeds up the refresh operation while not restricting the Table Editor's functionality.
On
Show row numbers This option switches the visibility of the row number column.
On
Make use of referential information
If this option is turned on, then for each foreign key column of a database table the Table Editor creates a combo box if the corresponding value should be edited (Edit Mode). The combo box is prefilled with all values from  the primary key column the foreign key refers to. Because the values are retrieved using a single column select the sort order depends on the database. That is why currently for keys that are composed of more than one column you cannot rely on the combo box value index when choosing values that refer to the same key.
On
Display binary values as strings by default
If this option is turned on , then the Table Editor displays the values of columns having a binary type as strings rather than in the hex format. Off
Show the table count in the status bar
If turned on, each time a Table Editor is opened or refreshed the SQL statement select count(*) from <table_name> is executed. If the tables you work with are too large to allow the statement to be executed within a few milliseconds you should turned this off.
On
Prefix to prepend before binary display values
This prefix string is prepended to binary display values. In previous releases this has been a constant value of '0x'.
Empty
Consider the string literal as SQL NULL
This string will be displayed if a value is SQL NULL. Furthermore if this value is typed into a cell when updating, the Table Editor would submit SQL NULL to the database.
The only reason why this should be changed is if a value is not  SQL NULL but '<NULL>'.
<NULL>
Maximal row count This value sets a limit on the Table Editor to stop refreshing if the specified row count has been read. As the refresh operation can be stopped by using the Cancel action, normally there should be no need to set a value here.

Incremental fetch count
This sets the initial count of rows that will be fetched from a table. The next rows can be retrieved using Ctrl+Alt+Page Down or the appropriate button from the Table Editor toolbar.
100
Initial column width
This value sets the column width of the Table Editors columns. If not specified, the columns will automatically be resized to fit their content.
Tip: By using the action Resize columns to fit the columns can be resized at any time.

Separator between columns for copy operation
This value will be inserted between the column values when copying the contents of the Table Editor by using the Copy operation.
', '
Default encoding used in result parts
Within this field you can specify the default encoding that is used for each new opening table result part. The specific encoding associated with one table result can later  be adjusted using the toolbar menu.
platform default encoding



Legal Notice