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.
A new line and a comma separate each column name after the copy.