# Delete Table Columns

### Overview

This procedure deletes a table's columns. It can be used to delete a single column or delete multiple columns from a table.

### Input Concepts

| Concept        | Type            | Description                             | Default    | Required |
| -------------- | --------------- | --------------------------------------- | ---------- | -------- |
| `column names` | list of strings | The names of the columns to be deleted. | No default | Yes      |

### Output Concepts

| Concept | Description                                           |
| ------- | ----------------------------------------------------- |
| `table` | The updated table with the specified columns removed. |

### Examples

In the examples below, `the table` refers to the following table, which can be generated using the `create a sample table` procedure:

| Name | Number             | Address          | City          |
| ---- | ------------------ | ---------------- | ------------- |
| john | + 1 (415) 691 9426 | 123 east street  | San Francisco |
| joe  | + 1 (415) 691 1234 | 321 west street  | San Jose      |
| jack | + 1 (415) 691 4595 | 213 north street | San Francisco |

#### 1. Deleting a Single Table Column

{% tabs %}
{% tab title="Automation" %}

```
delete the table's columns where
    the column names are "Number"
```

{% endtab %}

{% tab title="Results" %}

| Name          | Address          | City          |
| ------------- | ---------------- | ------------- |
| john          | 123 east street  | San Francisco |
| joe           | 321 west street  | San Jose      |
| jack          | 213 north street | San Francisco |
| {% endtab %}  |                  |               |
| {% endtabs %} |                  |               |

#### 2. Deleting Multiple Table Columns

{% tabs %}
{% tab title="Automation" %}

```
delete the table's columns where
    the column names are "Name", "Number"
```

{% endtab %}

{% tab title="Results" %}

| Address          | City          |
| ---------------- | ------------- |
| 123 east street  | San Francisco |
| 321 west street  | San Jose      |
| 213 north street | San Francisco |
| {% endtab %}     |               |
| {% endtabs %}    |               |