Show in new SQL Editor

www.altova.com Print this Topic Previous Page Up One Level Next page

Home >  User Reference > Menus > Design Editor Menu > SQL and Data >

Show in new SQL Editor

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


© 2019 Altova GmbH