Modify Column Definitions

To modify the SQL statement or any other information in a column, use the following steps:

1. Open the Tables window.
2. In the Tables pane, click the record for the table where the columns will be modified.
3. Click the Columns tab.
4. In the Columns tab, make the desired modifications to the calculation SQL.
5. Click .
6. Open the window that shows the data from the table.
7. Right-click and select Update Target Table. The system then re-calculates any calculated columns using the new column definitions.