Customizing Interactive SQL

You can customize Interactive SQL by configuring how result sets are displayed, disabling warning messages, and setting Interactive SQL as the default editor for .sql files.

Prérequis

There are no prerequisites for this task.

Contexte et remarques

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

Task

Open Interactive SQL and connect to a database.

Option	Action
Customize how result sets are displayed	Choose to show the results as a scrollable table or as text. 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. Execute a query. You must execute a new query for the changes to table editing to take effect. Right-click within the result set and choose one of the following: Size Columns To Data The table columns widen so that the values 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	You can disable some of the warning messages that appear in Interactive SQL. For example, you can suppress the warning that appears when you have unsaved text in the SQL Statements pane and you click File » Exit. Click Tools » Options » Messages. Clear the messages listed in the Optional Messages list.
Set Interactive SQL as the default editor for .sql files	Click Tools » Options » General. Click Make Interactive SQL The Default Editor For .SQL Files And Plan Files. Click OK.

Résultat

Interactive SQL is customized.

Customizing Interactive SQL

Task

See also