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