TRUNCATE

Purpose

Use this statement to completely delete the contents of a table.

Prerequisite

You need to have the system privilege DELETE ANY TABLE, object privilege DELETE on the table or its schema, or the table belongs to the current user or one of the user roles.

Syntax

truncate::=

Truncate_Statement

Example

TRUNCATE TABLE staff;