List Tables statement

Lists the existing logical tables within a project.

LIST [ALL] TABLES [IN FOLDER "location_path"] FOR PROJECT "project_name";

where:

• FOLDER "location_path" is the folder where the tables reside, of type string.

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

This statement can only be executed in a Windows environment.

Example

LIST ALL TABLES FOR PROJECT "MicroStrategy Tutorial";

ResultSet Columns

NAME: The name of the table, returned as a string.

PATH: The path to the table, returned as a string.

WAREHOUSE_TABLE_NAME: The name of the warehouse table, returned as a string.