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

SQL Anywhere 12.0.0 » SQL Anywhere Server - Database Administration » Administering your database » SQL Anywhere graphical administration tools » Using Interactive SQL

 

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 Configuring the administration tools.

 To customize Interactive SQL
  1. In Interactive SQL, choose Tools » Options.

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

  3. Click OK.

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

    For example, choose 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 monospaced 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