The LIST statement can be used to view the existing database objects in a solidDB® database. The LIST statement prints a list of specific database object types.
The object type is given as an argument. Any object name can be replaced with a wildcard expression (for example, foo%b_r). The wildcard '%' extends the scope to every possible object on that particular level.
The LIST statement can be used in companion with the DESCRIBE command asfollows:
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