The Column Picker enables you to select multiple columns for tables or views specified in a SELECT statement or similar syntax.

When the suggestions box is displayed, press Ctrl + Left arrow or click the Column Picker tab to display the Column Picker:

Primary key  and foreign key  columns are indicated by key icons.

The Column Picker is never automatically selected.

• The columns are listed in the order in which they are defined in the table. Clear the List in table order check box to list them alphabetically.
• The first column in the list is highlighted, but it is not selected. Only columns that you specifically check will be inserted.

Selecting columns

As you start typing, the list of columns is filtered to show only those that match the typed characters.

• Use the Up and Down arrow keys to navigate through the list.
• Press Space to select a column to be inserted.
• You can select all the columns in the list by pressing Ctrl + A or clicking the Select All button.

If you have already selected some columns and then filtered the list by typing some letters, the previously selected columns are listed at the bottom:

Inserting selected columns

Press the Enter or Tab key to insert the selected columns. The columns are inserted in the order in which you selected them.

 The inserted columns are automatically formatted depending on the options specified in the SQL Prompt Options dialog box:

• For SQL Prompt Pro Edition, under New lines on the Format > Data Statements page.
• For SQL Prompt Standard Edition, under Column Placement on the Format > Basic (Standard Edition) page.

If the format of the inserted columns doesn't look the way you want, you can change the formatting options and then apply the new format to the selected code:

From the SQL Prompt menu, select Format SQL.

Qualified column names

Inserted column names are qualified when:

• you have selected Qualify column names with table name on the Inserted code > Qualification options page, or
• you have specified more than one table in the FROM clause, and the column names would be ambiguous without also specifying their table

In the example below, both qualification options have been turned on:

In the example below, SQL Prompt has automatically qualified certain column names to avoid ambiguity:

When Assign aliases is turned on as well as Qualify column names with table name, columns are qualified with the table alias. For example:

You can customize how aliases are created and inserted. For more information, see Working with aliases.