Documentation Index

Fetch the complete documentation index at: https://kb.vastdata.com/llms.txt

Use this file to discover all available pages before exploring further.

table show

Prev Next

This command shows details of a specific table in a VAST Database.

Usage

table show --database-name DATABASE
           --schema-name SCHEMA
           --name TABLE
          [--tenant-id TENANT]          

Required Parameters

--database-name DATABASE

Specifies the name of the database containing the schema.

--schema-name SCHEMA

Specifies the name of the schema containing the table.

--name NAME

Specifies the name of a specific table.

Options

--tenant-id TENANT

Specifies the ID of the tenant where the database resides

If omitted, the default tenant is assumed.

Example

vcli: admin> table show  --database-name comet-job-bg --schema-name worker0 --name t15
+------------------------------+------------------------+
| Schema-name                  | worker0                |
| Is-external-rowid-alloc      | False                  |
| Num-rows                     | 3000                   |
| Sorting-key-enabled          | False                  |
| Sorting-done                 | False                  |
| Size                         | 676245                 |
| Database-name                | comet-job-bg           |
| Vector-index-column-name     | None                   |
| Partitions-config            | bucket(2, b)           |
| Vector-index-distance-metric | None                   |
| Name                         | t15                    |
+------------------------------+------------------------+