Help Center > > FAQs> Database Usage> How Do I Use DAS to Query SQL Statements?

How Do I Use DAS to Query SQL Statements?

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

DAS is a visual and professional database management tool. You can enable SQL Explorer to query related SQL statements.

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and a project.
  3. Click in the upper left corner of the page and choose Database > Relational Database Service. The RDS console is displayed.
  4. On the Instance Management page, locate the target DB instance and click Log In in the Operation column.

    Figure 1 Logging in to a database

  5. On the displayed login page, enter the correct username and password and click Log In.
  6. In the navigation pane, choose Cloud DBA (Intelligent O&M) to go to the Instance Overview page.
  7. Locate the instance you want to view and click Details.
  8. On the SQL tab page, click SQL Explorer to view the full SQL details of the current instance.
  9. On the SQL List tab page, click Enable DAS SQL Explorer. You can set the time range, user, keyword, operation type, and database and click Query to obtain the SQL statements executed on the current instance.

    Figure 2 Enabling SQL Explorer

  10. Filter operation types by referring to Table 1 and click Export to export the corresponding SQL statements.

    Table 1 Common SQL statement types

    Type

    Keyword

    DDL

    CREATE, DROP, ALTER

    DML

    INSERT, UPDATE, DELETE, SELECT

    DCL

    GRANT, REVOKE

    A maximum of 10,000 SQL statements can be displayed. If you need to view more, click Export to export them.

    A maximum of 100,000 records can be exported.

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