Altova DatabaseSpy 2024 Professional Edition

The Show in new SQL Editor command opens a sub-menu which enables you to create SQL statements from the selected tables in the Design Editor.

sbmnu-show-in-new-sql-editor

If more than one table is selected, a statement is created for each of the selected tables. Please note that different statements are created depending on what you have selected:

 

If you have selected the entire table, one statement is created for all of the columns in the table.

sql_select-table

If you have selected a single column, the statement is created for this particular column only.

sql_select-column

If you have selected some but not all of the columns, one statement is created for the selected columns.

sql_select-columns

© 2017-2023 Altova GmbH