Топ-100
 
CerebroSQL

TRUNCATE TABLE

RDBMS Type: Oracle

unnamed (2).png

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;