MicroStrategy ONE

Remove Table / Warehouse Table statement

Removes a table from a project.

Copy 
REMOVE (WHTABLE "warehouse_table_name"| TABLE "table_name") FROM PROJECT "project_name";

where:

  • TABLE "table_name" is the name of the logical table to be removed from the project, of type string.

  • WHTABLE "warehouse_table_name" is the name of the warehouse table to be removed from the project, of type string.

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

When you remove a table:

  • If you remove a warehouse table from a project, all of its depending tables are removed too.

  •  If you remove the only logical table of a warehouse table, the warehouse table is removed too.

  • Make sure the logical table does not have any dependent objects.

This statement can only be executed in a Windows environment.

Examples

Copy 
REMOVE TABLE "DT_YEAR1" FROM PROJECT "MicroStrategy 
 Tutorial";
Copy 
REMOVE WHTABLE "DT_YEAR" FROM PROJECT "MicroStrategy 
 Tutorial";