table list

Prev Next

This command lists tables in a VAST Database.

Usage

table list --database-name DATABASE
           --schema-name SCHEMA
          [--name TABLE]
          [--page PAGE_NUMBER]
          [--page-size PAGE_SIZE]
          [--name-startswith PREFIX]
          [--tenant-id TENANT]          

Required Parameters

--database-name DATABASE

Specifies the name of the database that contains the schema.

--name SCHEMA_NAME

Specifies the name of the schema  containing the table.

Options

--page PAGE

Specifies the specific page in the output list, by its number. This parameter is used only  if page-size is set. Default is the first page.

--page-size PAGE_SIZE

Specifies the maximum number of tables to list per output page. Default: 100.

--name TABLE

Specifies the name of a specific table. If included, only this table is shown.

--name-startswith PREFIX

Specifies a prefix to filter the table names.

--tenant-id TENANT

Specifies the ID of the tenant where the database resides

If omitted, the default tenant is assumed.

Example

vcli: admin> table list --database-name  tabular-industrious --schema-name schema_abc
+------------------+-------------------------------------+-------------------+----------+----------+
| Name             | Database-name                       | Schema-name       | Num-rows | Size     |
+------------------+-------------------------------------+-------------------+----------+----------+
| table_mdihlhrzdy | tabular-industrious                 | schema_abc        | 6400000  | 70400000 |
+------------------+-------------------------------------+-------------------+----------+----------+