Working with Columns in the SQL Diagram Pane

Go Up to Using Query Builder

You can customize queries by selecting and deselecting columns in the SQL Diagram Pane. You can customize columns using the Selected Column Properties dialog box. For details, see Column Properties.

Selecting and deselecting columns

You can select and deselect columns in the SQL Diagram. Query Builder lets you select and deselect individual columns or all columns. Your results reflect the order of selection. You can change the order of columns after you set them in your diagram or statement.

Tip: You can also select, re-order and deselect columns in the SQL Statement Tree. For more information, see Selecting Columns in the SQL Statement Tree.

Selecting Individual Columns

To select individual columns, do the following:

1. To select a column, in the SQL Diagram, select the check box to the left of the target column name.

Deselecting Individual Columns

To deselect individual columns, do the following:

1. To deselect a column, in the SQL Diagram, select the check box to the left of the target column name.

Note: When you clear the columns, Query Builder deletes the columns and any sub clauses from the SQL Statement Pane and SQL Statement Tree.

Selecting All Columns

To select all columns, do the following:

1. On the Query Builder menu, click Select Star.

Note: Query Builder uses columns in statements based on the order of selection. When you select all columns, Query Builder displays the columns as they appear in the table.

Deselecting All Columns

To deselect all columns, do the following:

1. On the Query Builder menu, click Select None.

   Query Builder adds or removes selected columns from the SQL Statement Tree and the SQL Statement Pane.