---
title: "Managing Table Projections"
slug: "managing-table-projections"
tags: ["5.4"]
updated: 2026-10-28T01:53:23Z
published: 2026-10-28T01:53:23Z
canonical: "docs.vastdata.com/managing-table-projections"
---

> ## 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.

# Managing Table Projections

Table Projections are subsets of a full table in the VAST Database that allow for optimized queries that use only the columns included in the projection. You can select up to four columns to be used to sort the projection, and an unlimited number of additional columns to include in the projection, which are not used to sort the projection.

- [Viewing Table Projections](/docs-5-4/docs/en/managing-table-projections#viewing-table-projections)
- [Creating a Table Projection](/docs-5-4/docs/en/managing-table-projections#creating-a-table-projection)
- [Renaming a Table Projection](/docs-5-4/docs/en/managing-table-projections#renaming-a-table-projection)
- [Deleting a Table Projection](/docs-5-4/docs/en/managing-table-projections#deleting-a-table-projection)
- [Managing Table Projections using the VAST CLI](/docs-5-4/docs/en/managing-table-projections#managing-table-projections-using-thevast-cli)

## Limitations

Table projections cannot be added to [​sorted tables](/docs-5-4/docs/sorted-tables)​​, and tables with projections cannot be sorted.

​

## Managing Table Projections using the VAST Web UI

### Viewing Table Projections

1. From the left navigation menu, select DataBase and then VAST DB, to show a list of all databases.
2. Expand the relevant database, then under the database, expand the schema to which the table belongs, and then under the schema expand the table of interest. If the table has any projections, they are displayed as children of the table.
3. Select a projection to show details of the columns included in the projection.

### Creating a Table Projection

1. From the left navigation menu, select DataBase and then VAST DB, to show a list of all databases.
2. Select the database, schema, and table in which the projection will be created.
3. Click Add Projection. Enter a name for the projection.
4. Select the columns that will be included in the projection. Select up to four columns that are sorted, and an unlimited number of unsorted columns.

> [!NOTE]
> **Note**
> 
> Rows in the projection are sorted according to the columns selected as 'sorted', in the order the are selected. So, if you select columns A, B, C, and D as sorted, the rows in the projection are sorted according to the values in these columns, in this order.
5. Click Create.

### Renaming a Table Projection

1. From the left navigation menu, select DataBase and then VAST DB to show a list of all databases.
2. On the left, select a database, schema, table, and projection. Details are shown of the projection.
3. Click ![edit-symbol.png](https://cdn.us.document360.io/89b91113-5dc6-49db-86ec-57b16dc8ce56/Images/Documentation/img-39bb44fdf2cc6fb9af145d1482b3f171(13).png?sv=2026-02-06&spr=https&st=2026-11-08T09%3A37%3A16Z&se=2026-11-08T10%3A37%3A16Z&sr=c&sp=r&sig=QBh8lVqkl3EgbnmmHUBbo8u78MmHCdud7YkAr1YoHiQ%3D) next to the projection name, and then edit the name.
4. Click Save.

### Deleting a Table Projection

1. From the left navigation menu, select DataBase and then VAST DB to show a list of all databases.
2. On the left, select a database, schema, and table. The projections for the table, if any, are shown below the table.
3. Select a projection. Details are shown of the projection.
4. Click ![Three-dots-symbol.png](https://cdn.us.document360.io/89b91113-5dc6-49db-86ec-57b16dc8ce56/Images/Documentation/img-ef3b4a6ef899f1ddb8faa02b4291e93c(11).png?sv=2026-02-06&spr=https&st=2026-11-08T09%3A37%3A16Z&se=2026-11-08T10%3A37%3A16Z&sr=c&sp=r&sig=QBh8lVqkl3EgbnmmHUBbo8u78MmHCdud7YkAr1YoHiQ%3D), and then select Delete.

## Managing Table Projections using the VAST CLI

Use these VCLI commands to manage table projections on VAST Database tables.

| Action | Command |
| --- | --- |
| Create a projection in a table | `projection create` |
| LIst all projections in a table | `projection list` |
| Show details for a projection | `projection show` |
| Rename a projection | `projection rename` |
| Delete a projection | `projection delete` |
| List the columns in a projection | `projectioncolumn list` |
| Show details for a column in a projection | `projectioncolumn show` |