MicroStrategy ONE

Update Schema statement

Updates the schema for a given project.

Copy
UPDATE SCHEMA [REFRESHSCHEMA] [RECALTABLEKEYS] [RECALTABLELOGICAL] [RECALOBJECTCACHE] FOR PROJECTproject_name;

where:

project_name is the name of the project for which the schema is to be updated, of type string, between double quotes (" ").

Examples

Copy
UPDATE SCHEMA FOR PROJECT "MicroStrategy Tutorial";
Copy
UPDATE SCHEMA REFRESHSCHEMA FOR PROJECT "MicroStrategy Tutorial";
Copy
UPDATE SCHEMA REFRESHSCHEMA RECALTABLEKEYS RECALTABLELOGICAL RECALOBJECTCACHE FOR PROJECT "MicroStrategy Tutorial";