Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database administration » SQL Anywhere graphical administration tools » Interactive SQL

 

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.

Prerequisites

There are no prerequisites for this task.

Context and remarks

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
    1. 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.

    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 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.

    1. Click Tools » Options » Messages.

    2. Clear the messages listed in the Optional Messages list.

    Set Interactive SQL as the default editor for .sql files
    1. Click Tools » Options » General.

    2. Click Make Interactive SQL The Default Editor For .SQL Files And Plan Files.

    3. Click OK.

Results

Interactive SQL is customized.

 See also