Customizing Interactive SQL

You can configure settings for the tabs and panes in Interactive SQL using the Options window. When you deploy Interactive SQL, you can control which features are shown or enabled in the Options window. See Administration tools configuration.

 Customize Interactive SQL
  1. In Interactive SQL, click Tools » Options.

  2. In the left pane, click an option and specify the options that you want.

  3. Click OK.

 Configure how result sets are displayed in Interactive SQL
  1. Choose to show the results as a scrollable table or as text.

    For example, click Data and then choose one of the following:

    • Show Results As Scrollable Table   You can edit the result set in this format. This is the default.

    • Show Results As Text   This option displays the result set as text using a monospace font. The result set is not editable in this format.

  2. Execute a query.

    You must execute a new query for the changes to table editing to take effect.

  3. Right-click within the result set and choose one of the following:

    • Size Columns To Data   The table columns are made wide enough so that the values they contain are not truncated.

    • Size Columns To Window   The table columns are made the same width so they all fit within the window without a horizontal scroll bar.

 Disable warning messages
 See also