Топ-100
 

TRUNCATE TABLE

Описания команд доступны в программе CerebroSQL

RDBMS Type: Oracle
Topic

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;