Changing an existing item table

Note: This feature is available only with a Sage Estimating (SQL) SQL product license. (It is not available with Sage Estimating Essential.)

To change an item table:

1. Open the Database Item Table window in one of the following ways:

   • On the ribbon, from the Elements group on the Data tab, click Item Tables.
   • In classic view, select Database menu > Assemblies > Item Tables.
2. Beside the Item table box, click to display the Item Table List, and then double-click the item table you want to change.
3. In the Database Item Table window, update the table as needed.

   • To change the table name, click [Rename] and enter the new name in the Item table field.

   • To insert a row above the current row, click the right mouse button in the leftmost cell of the row and select Insert Row from the shortcut menu.

   • To delete a row, click the right mouse button in the leftmost cell of the row and select Delete Row from the shortcut menu.

   • To insert a column to the left of the current column, click [Insert] and select Column from the shortcut menu. Inserting a column in a one-dimensional table changes the table into a two-dimensional table.

   • (two dimensional table) To delete a column, click the right mouse button in the column’s input range cell and select Delete Column from the shortcut menu.

4. When you finish changing the item table, click [OK] to save it.
5. Change other item tables in the same manner.
6. When you finish, click [Close] to close the Item Table window, and then click [Cancel] to close the Item Table List.