MicroStrategy ONE

Alter Table statement

Modifies a logical table within a project.

Copy 
ALTER TABLE 
 "table_name"[NAME "new_table_name"] 
 [DESCRIPTION "new_description"][LONGDESCRIPTION 
 "long_description"][FOLDER "new_location_path"] 
 [HIDDEN (TRUE | FALSE)] [LOGICALSIZElogical_size] [PRESERVELOGICALSIZE 
 (TRUE | FALSE)] FOR PROJECT "project_name";

where:

  • TABLE "table_name" is the name of the logical table to be modified of type string.

  • NAME "new_table_name" is the new name of the table, of type string.

  • DESCRIPTION "new_description" is the new description of the table, of type string.

  • LONGDESCRIPTION "long_description" is the new long description of the table, of type string.

  • FOLDER "new_location_path" is the folder where the logical table is to be placed, of type string.

  • HIDDEN indicates whether the table's Hidden flag is set.

  • LOGICALSIZE logical_size is the logical size of the logical table, of type integer.

  • PRESERVELOGICALSIZE indicates whether to preserve the table's logical size.

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

This statement can only be executed in a Windows environment.

Example

Copy 
ALTER TABLE "DT_QUARTER" LOGICALSIZE 10 
 PRESERVELOGICALSIZE TRUE FOR PROJECT "MicroStrategy Tutorial";