SQL Guide : solidDB® SQL statements : LIST
  
LIST
LIST <statement>
where
statement :=
CATALOGS |
USERS |
ROLES |
[catalog.]SCHEMAS |
[catalog.]MASTERS |
[catalog.]REPLICAS |
[catalog.]SUBSCRIPTIONS |
[catalog.]PUBLICATIONS |
[[catalog.]schema.]TABLES |
[[catalog.]schema.]VIEWS |
[[catalog.]schema.]PROCEDURES |
[[catalog.]schema.]FUNCTIONS |
[[catalog.]schema.]EVENTS |
[[catalog.]schema.]SEQUENCES |
[[[catalog.]schema.]table.]INDEXES | [[[catalog.]schema.]table.]TRIGGERS
Usage
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 as follows:
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

1 rows fetched.
See also
solidDB® SQL statements