Help Center > > User Guide> GaussDB (for openGauss) DB Instance Management (Development Tool)> SQL Operations> SQL Window

SQL Window

Updated at: Jun 09, 2021 GMT+08:00

Procedure

  1. Log in to the GaussDB(for openGauss) management homepage.
  2. On the top menu bar, choose SQL Operations > SQL Window.
  3. Check whether there are any schemas other than system schemas exist.
  4. If not, create a schema according to Creating a Schema and then perform SQL operations.

    After a database is created, you need to create a schema before performing any SQL operations.

  5. In the navigation pane, select a database, and then specify a table or view.

    Figure 1 SQL Window
    • Execute SQL: executes SQL statements.
    • Execute SQL Plan: reports the execution of SQL statements to facilitate troubleshooting and optimize SQL processing performance.
    • SQL Favorites: allows you to add, view, and manage frequently used SQL statements.
    • Format SQL: improves the readability of SQL statements. Formatting SQL statements enables statements to be displayed in line break mode, but does not change their logic and semantics.

      The formatting takes effect for all the SQL statements in the SQL window. You cannot format only the selected statements.

    • SQL Input Prompt: helps you to select your desired database, table, or field name as prompted to quickly enter statements in the SQL window.
    • Overwrite/Append Mode:
      • Append Mode: Each time a SQL statement is executed, the new result set is appended to the previous one.
      • Overwrite Mode: Each time a SQL statement is executed, the new result set overwrites the previous one.
    • Full Screen: shows SQL statements on a full screen.
      Figure 2 SQL statements before formatting
      Figure 3 SQL statements after formatting

  6. After SQL statements are executed, view SQL execution status on the Executed SQL Statements, Messages, and Result Set tab pages.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel