solidDB Help : solidDB reference : SQL: Statements : LIST
  
LIST
LIST {CATALOGS | USERS | ROLES | REPLICATION CONNECTIONS | REPLICATION SUBSCRIPTIONS | REPLICATION PARTITIONS |
   [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}
Access requirements
Database user
Usage
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

1 rows fetched.
LIST REPLICATION CONNECTIONS;
REPLICATION CONNECTIONS:
------------------------
CONNT1
CONN_602
CONN_PART_01
1 rows fetched.
LIST REPLICATION PARTITIONS;
REPLICATION PARTITIONS:
-----------------------
PART1
PAR_1160_WADP1M_1
PAR_4444_WAFB0A01
TEST_PART_01
TEST_PART_02
TFEC_2XX_PART_01
1 rows fetched.
LIST REPLICATION SUBSCRIPTIONS;
REPLICATION SUBSCRIPTIONS:
--------------------------
SUBST1
SUBS_1160_WADP1M_1
SUBS_4444_WAFB0A01
TEST_PART_01
TEST_PART_02
TFEC_2XX_SUB_01
1 rows fetched.
Go up to
SQL: Statements