Please enable JavaScript to view this site.

Altova DatabaseSpy 2021 Professional Edition

User Reference > Menus > SQL Refactoring Menu

Expand Columns for Star Expressions

Scroll Home Prev Top Next More

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.

© 2020 Altova GmbH