To facilitate the construction of a SQL statement, copy the selected column names to the SQL Optimizer or SQL Formatter windows.
To copy column names
Select the table or view name displayed on the tree diagram in the left pane [Database Objects] of the Database Explorer window.
Make sure the Column tab is active and select the column names by clicking the left-hand mouse button with the Shift key for multiple selections.
Right-click and select Copy columns to SQL Optimizer to copy the column names to the SQL Optimizer window or select Copy columns to SQL Formatter to copy the column names to the SQL Formatter window.
A new line and a comma separate each column name after the copy.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Conditions d’utilisation Confidentialité Cookie Preference Center