Update Structure statement

Update a table with its new structure obtained from the warehouse.

To update structure for a warehouse table, you will need to provide a name. Command Manager will search for the table and update its column structure. All the logical tables using this warehouse table will also get their definitions updated. If no table name was provided, Command Manager will proceed to update all warehouse tables currently existed in the project.

UPDATE 
 STRUCTURE COLMERGEOPTION (RECENT | MAXDENOMINATOR | NOMERGE) [FOR WHTABLE 
 "table_name"] FOR PROJECT 
 "project_name";

where:

• COLMERGEOPTION indicates how to handle identical columns of different data types:

  • RECENT uses the most recent column definition.

  • MAXDENOMINATOR uses the column definition with the largest precision or scale.

  • NOMERGE renames the column in the newly added table, allowing the two columns to have different data types.

• WHTABLE "table_name" is the name of the table to be updated, of type string.

• PROJECT "project_name" is the name of the project, of type string.

This statement can only be executed in a Windows environment.

Example

UPDATE STRUCTURE COLMERGEOPTION MAXDENOMINATOR FOR 
 WHTABLE "DT_YEAR" FOR PROJECT "MicroStrategy Tutorial";