Altova DatabaseSpy 2023 Enterprise Edition

The Formatting section of the Options dialog box lets you switch off SQL formatting for the SQL Editor and Change Script windows and configure the behavior of open SQL Editor windows.

dlg_options-gen-sql-formatting

 

SQL Formatting

You can disable the SQL formatting options for the Change Script window and/or the SQL Editor by deactivating the respective check boxes. Note that in the Change Script window, SQL formatting is applied automatically when the next change is recorded, and that you cannot apply formatting without changing the database structure.

 

Update behavior after changing Formatting Configurations

This group box allows you to specify whether or not open SQL Editor windows should be automatically updated after formatting configurations have changed or if a prompt should be displayed, where you can choose to update the windows or to keep the existing formatting.

 

SQL Formatting Configurations

The SQL Formatting Configurations... button opens the SQL Formatting Configuration dialog box, where you can define the configurations for the different database types or disable formatting on database or even statement type level.

© 2017-2023 Altova GmbH