All Products
Search
Document Center

Restore SQL windows

Last Updated: Jun 07, 2019

This topic describes how to save and restore SQL windows.

Prerequisites

You have access permissions to DMS and you have logged on to the DMS console.

Background

  • This example uses MySQL databases.
  • You can open or save a maximum of 20 SQL windows in DMS. We recommend that you open a maximum of 5 windows at one time.

Procedure

  1. Select a MySQL database, and click Log on to Database.

  2. In the top navigation bar, choose SQL Operations > SQL Window.

  3. Save the operating environment of the current SQL window.

    1. DMS automatically saves the operating environment when you close the operation page.

    2. The next time you log on to the DMS console, DMS automatically restores the previous operating environment, including the last used database, the SQL windows that you opened, and the SQL statements you entered in the SQL windows.

      • The last used database.
      • The SQL windows that you opened.
      • The SQL statements you entered in the SQL windows.
    3. Before you close a SQL window, DMS prompts you to confirm whether you want to save the content of the SQL window, as shown in the following figure.

      Save the SQL window

      Notes

      • Callout number 1: Click the Close button in the upper-right corner of the SQL window to close the window.

      • Callout number 2: DMS prompts you to save the content of the SQL window. Click Close and Save Content. DMS saves the content of the SQL window before you close the window.

      • If you click Close Now, DMS will not save the content of the SQL window.

  1. Restore a saved SQL window.

    1. Choose SQL Operations>Saved SQL Editor Windows. DMS displays all the saved SQL windows.

      Saved SQL windows are listed as follows:

      Saved SQL editor windows

      Notes

      • Callout number 1: Saved SQL windows.

      • Callout number 2: Click View SQL to restore the saved SQL window

    2. When you log on to the database from DMS, DMS automatically restores the content of the last saved SQL window.