1 of 1

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

Output Concepts

Concept

Description

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

1. Deleting a Single Table Column

Name

Address

City

2. Deleting Multiple Table Columns

Address

City

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

Output Concepts

Concept

Description

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

1. Deleting a Single Table Column

Name

Address

City

2. Deleting Multiple Table Columns

Address

City

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

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

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