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.