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

SQL Window

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

Procedure

  1. In the keyspace list of the Home page, locate the target keyspace and click Query SQL Statements in the Operation column to open the SQL window.

    You are advised to enable Save Executed SQL Statements in the upper right corner so that the recently executed SQL statements can be saved to the server.

  2. In the navigation pane on the left, select a keyspace, and specify a table or view.

    Figure 1 SQL operations
    • Execute SQL: executes 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 Favorites: allows you to add, view, and manage frequently used SQL 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.

  3. After SQL statements are executed, view SQL execution status on the Executed SQL Statements, Messages, and Result 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