Introduction

---

The SQL EMPTY TABLE statement is used to empty a table of all data.

Syntax

---

EMPTY TABLE [IF EXISTS] table_reference

Use the EMPTY TABLE statement to remove all data from an existing table. The statement below empties a table:

EMPTY TABLE Employee

Please see the Emptying Tables topic for more information on emptying tables.