Delete Columns

Deletes one or more specified columns from a table.

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 [phone]	123 east street	San Francisco
joe	+ 1 [phone]	321 west street	San Jose
jack	+ 1 [phone]	213 north street	San Francisco

1. Deleting a Single Table Column

Automation

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

Results

Name	Address	City
john	123 east street	San Francisco
joe	321 west street	San Jose
jack	213 north street	San Francisco

2. Deleting Multiple Table Columns

Automation

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

Results

Address	City
123 east street	San Francisco
321 west street	San Jose
213 north street	San Francisco