---
title: "column list"
slug: "column-list"
updated: 2026-10-27T17:24:31Z
published: 2026-10-27T17:24:31Z
canonical: "docs.vastdata.com/column-list"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vastdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# column list

This command lists columns in a VAST Database table.

## Usage

```plaintext
column list --database-name DATABASE 
            --schema-name SCHEMA
            --table-name TABLE
           [--page PAGE]
           [--page-size PAGE_SIZE]
           [--name COLUMN_NAME]
           [--name-startswith PREFIX]
           [--tenant-id TENANT]
```

## Required Parameters

| `--database-name DATABASE` | Specifies the name of the database containing the table. |
| --- | --- |
| `--schema-name SCHEMA` | Specifies the name of the schema containing the table. |
| `--table-name TABLE` | Specifies the name of the table containing the columns. |

## 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 columns to list per output page. Default: 100. |
| `--name COLUMN_NAME` | Specifies the name of a specific column. |
| `--name-startswith PREFIX` | Specifies a prefix to filter the column names. |
| `--tenant-id TENANT` | Enter the ID of the tenant where the database resides If omitted, the default tenant is assumed. |

## Example

```plaintext
vcli: admin> column list --database-name table-1 --schema-name schema_jypxvnuobg --table-name table_jypxvnuobg
+--------------+-------------------+----------------------------------+-------------------+------------------+
| Name         | Raw-field         | Database-name                    | Schema-name       | Table-name       |
+--------------+-------------------+----------------------------------+-------------------+------------------+
| theage       | int8              | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thestate     | string            | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thedate      | date32[day]       | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thetinyint   | int8              | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| theint       | int32             | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thebigint    | int64             | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thetime      | time32[ms]        | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thetimestamp | timestamp[ms]     | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thevarchar   | string            | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thebool      | bool              | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thereal      | float             | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thedouble    | double            | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
| thedecimal   | decimal128(38, 0) | table-1                          | schema_jypxvnuobg | table_jypxvnuobg |
+--------------+-------------------+----------------------------------+-------------------+------------------+
```