Data Visualization

For a series of operations on the table, we will introduce them separately:

• Open Table: open the table structure to view data
• Query console: Create a new console based on this database
• Pin: pin list
• View DDL: View the DDL statements of the table
• Edit Table: Edit table (table name, comments, column names, primary keys...)
• Copy name: Copy the table name
• Refresh: Refresh the table
• Delete Table: delete table
• Generate Test Data: Generate test data for developers to use

View data

When you double-click a table in Database Explorer (View | Tool Windows | Database Explorer), the table, view, opens in the Data Editor. Or you can right-click the mouse to select the table you want to view and click Open Table to view it!

Edit data

You can make modifications directly in the table. After modifying the data, submit it and the modification will be successful!

In addition, you can also view the DDL statements for specific modification operations:

Refresh data

If you want to synchronize the data you see in the editor with the contents of the database, you need to reload the table view's data.

• Click the refresh button on the toolbar.

• Right-click on the table and select Reload Page from the context menu.

Save Console

Click Save in the toolbar to save everything written in the console (although no SQL statement is executed)!

View SQL log

Click Executive logging on the right side to view the execution record log.

Format SQL

Click Format in the toolbar to format the SQL statement!