up

1. Format SQL scripts according to customization options
2. Execute SQL in one statement
3. Execute SQL in multiple statements
4. Execute SQL at cursor position (or selected SQL)
5. Display SQL query history
6. Print editor content and query table results

1. Format SQL scripts according to customization options

DtSQL allows users to format SQL scripts in the SQL editor

• Config SQL format rules:
  • Select 'Tools' -> 'Preferences' -> 'SQL Formatting'

• Change the SQL format rules, and click 'Save' button to apply the change
• Right click SQL editor and select 'Format SQL'

• The SQL scripts in the SQL editor will be formatted.

2. Execute SQL in one statement

DtSQL allows users to execute all SQL scripts in the SQL editor in one statement. Click 'Execute SQL (All In One)' menu button to execute all the SQl scripts in the SQL editor. This function is useful when it contains multiple SQLs. For example : SQL scripts to create function or procedure.

3. Execute SQL in multiple statements

DtSQL allows users to execute all SQL scripts in the SQL editor in multiple statements (one statement per SQL script). Click 'Execute SQL (All In One)' menu button to execute all the SQl scripts in the SQL editor.

4. Execute SQL at cursor position (or selected SQL)

DtSQL allows users to execute SQL script at the cursor position or selected SQL in one statement. Click 'Execute SQL (Current Statement)' menu button to execute SQL script at the cursor position(or selected SQLif it is available) in the SQL editor.

5. Display SQL query history

DtSQL can show the all SQL history. Select menu 'SQL' -> 'SQL History' to show all executed SQL.Click the SQL row to show the detail SQL in the text area.

6. editor content and query table results

DtSQL allows users to print the editor SQL scripts and query table results. Click the 'Print' menu button to print the editor SQL scirpts and click the 'Print' menu button in the table panel to print the query result.