Clear a Table

Clears all data from a table.

Overview

This procedure removes all the data from a table while keeping the structure (columns) of the table.

Input Concepts

Concept
Type
Description
Default
Required

table

table

The table to be cleared.

No default

Yes

Output Concepts

Concept
Description

table

The cleared table with all data removed but columns retained.

Examples

1. Clear the Table

In the example 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

clear the table

Last updated

Was this helpful?