Altova DatabaseSpy 2024 Enterprise Edition

Expand Columns for Star Expressions

Home Prev Top Next

The Expand columns for star expressions command inserts the full column list of a table if the cursor is placed after the asterisk in a SELECT statement and the command is executed.

 

Note that the SQL statement must be complete and valid. If, for example, the SQL Editor should require semicolons option is checked, the terminating semicolon must indeed be present in the SQL Editor.

© 2017-2023 Altova GmbH