---
title: "projection list"
slug: "projection-list"
tags: ["5.5"]
updated: 2026-10-27T23:00:54Z
published: 2026-10-27T23:00:54Z
canonical: "docs.vastdata.com/projection-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.

# projection list

This command shows the projections for a specific VAST Database table.

## Usage

```plaintext
projection list --database-name DATABASE 
                --schema-name SCHEMA 
                --table-name TABLE 
               [--page PAGE]
               [--page-size PAGE_SIZE]
               [--name PROJECTION]
               [--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. |

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

## Examples

```plaintext
vcli: admin> projection list --database-name tabular --schema-name vastagoda --table-name agoda
+-----------+---------------+-------------+------------+------------+------------+---------------+
| Name      | Database-name | Schema-name | Table-name | Properties | Num-rows   | Size          |
+-----------+---------------+-------------+------------+------------+------------+---------------+
| agodaproj | tabular       | vastagoda   | agoda      | None       | 9569577211 | 2077351076539 |
| myProj    | tabular       | vastagoda   | agoda      | None       | 9377687803 | 936625528087  |
| myProj2   | tabular       | vastagoda   | agoda      | None       | 9377687803 | 1364574579040 |
+-----------+---------------+-------------+------------+------------+------------+---------------+
```