Топ-100
top of page
CerebroSQL

TRUNCATE TABLE

RDBMS Type: Oracle

TRUNCATE TABLE [schema.] table
[ {PRESERVE | PURGE} MATERIALIZED VIEW LOG ]
[ {DROP [ ALL ] | REUSE} STORAGE ] ;

Example

TRUNCATE TABLE employees_demo;

TRUNCATE TABLE sales_demo PRESERVE MATERIALIZED VIEW LOG;

TRUNCATE TABLE orders_demo;

bottom of page