Use the LIST statement to print a list of the existing database objects in a solidDB database.
Any object name can be replaced with a wildcard expression (for example, my_catalog.%.TABLES). The % wildcard extends the scope to every possible object on that particular level.
The LIST statement can be used in conjunction with the DESCRIBE statement. For example, use the following statements to find the names of all the procedures in a database and then print the detail of a specific procedure:
LIST my_catalog.my_schema.PROCEDURES DESCRIBE my_catalog.my_schema.certain_procedure
Note LIST PROCEDURES lists all user-defined SQL and external procedures. System procedures are not listed. LIST FUNCTIONS lists all user-defined SQL and external functions.
Examples
LIST my_schema.TABLES;
Catalog: my_catalog Schema: my_schema TABLES: ------- CITY PERSON
1 rows fetched.
LIST my_catalog.%.TABLES;
Catalog: my_catalog Schema: my_schema TABLES: ------- PERSON IN_RELATION CITY CAR Schema: another_schema TABLES: ------- HORSENAME