---
title: "projectioncolumn list"
slug: "projectioncolumn-list"
updated: 2026-10-27T17:24:38Z
published: 2026-10-27T17:24:38Z
canonical: "docs.vastdata.com/projectioncolumn-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.

# projectioncolumn list

This command lists the columns in a VAST Database table projection.

## Usage

```plaintext
projectioncolumn list --database-name DATABASE
                      --schema-name SCHEMA
                      --table-name TABLE
                     [--name PROJECTION]
                     [--page PAGE]
                     [--page-size PAGE_SIZE]
                     [--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` | Specifies the ID of the tenant where the database resides If omitted, the default tenant is assumed. |

## Example

```plaintext
vcli: admin> projectioncolumn list --database-name tabular --schema-name vastagoda --table-name agoda --projection-name myProj2
+------------+---------------+-----------+---------------+-------------+------------+-----------------+
| Name       | Raw-field     | Is-sorted | Database-name | Schema-name | Table-name | Projection-name |
+------------+---------------+-----------+---------------+-------------+------------+-----------------+
| id         | string        | True      | tabular       | vastagoda   | agoda      | myProj2         |
| logtime    | timestamp[ns] | True      | tabular       | vastagoda   | agoda      | myProj2         |
| user_id    | string        | True      | tabular       | vastagoda   | agoda      | myProj2         |
| currency   | string        | True      | tabular       | vastagoda   | agoda      | myProj2         |
| session_id | string        | False     | tabular       | vastagoda   | agoda      | myProj2         |
| is_nha     | bool          | False     | tabular       | vastagoda   | agoda      | myProj2         |
| language   | string        | False     | tabular       | vastagoda   | agoda      | myProj2         |
| member_id  | int64         | False     | tabular       | vastagoda   | agoda      | myProj2         |
+------------+---------------+-----------+---------------+-------------+------------+-----------------+
```