MicroStrategy ONE

Remove folder contents statement

Delete all the contents of a folder.

Copy
REMOVE FOLDER CONTENT [CASCADE] "folder_name" 
 IN "location_path" FROM PROJECT "project_name";

where:

  • the CASCADE option means that subfolders are also deleted.

  • folder_name is the name of the folder whose contents are to be deleted, of type string, between double quotes (").

  • location_path is the path to the folder in the project, of type string, between double quotes (").

  • project_name is the name of the project containing the folder, of type string, between double quotes (").

Example

Copy
REMOVE FOLDER CONTENT CASCADE "Temporary Metrics" 
 IN "\Application Object\Metrics\ 
 FROM PROJECT Development Environment 2;