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

Automation

clear the table

Results