MicroStrategy ONE

Get Tables statement

Gets all the tables from a given expression within a project.

Copy
GET TABLES FROM EXPRESSION expression 
 IN PROJECT project_name;

where:

  • expression is the expression from which the tables are to be obtained, of type string, between double quotes (").

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

This statement can only be executed in a Windows environment.

Example

Copy
GET TABLES FROM EXPRESSION "CUSTOMER_ID" IN 
 PROJECT "MicroStrategy Tutorial";

ResultSet Columns

TABLES: The names of the tables obtained from the given expression, returned as a string.