TRUNCATE

Purpose

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

Prerequisite

  • You need either the system privilege USE ANY SCHEMA or the object privilege USAGE on the target schema, or the schema must be owned by you or one of your assigned roles.

  • You need the system privilege DELETE ANY TABLE or the object privilege DELETE on the table or its schema, or the table must be owned by you or one of your assigned roles.

Syntax

truncate::=

Truncate_Statement

Example

TRUNCATE TABLE staff;