Is TRUNCATE a DML instruction?

Question

Is it possible to classify / say that TRUNCATE belongs / belongs to the DML operator?

Check here for compatibility with PostgreSQL TRUNCATE.

NOTE. TRUNCATE is part of the standard SQL ANSI SQL 2008 - F200

Answer 1

PostgreSQL

I would say that this is a DML statement in PostgreSQL: PostgreSQL has a TRUNCATE trigger , but PostgreSQL does not have DDL triggers. Therefore, it cannot be a DDL expression.

ACCESS EXCLUSIVE , , MVCC-, , .

TRUNCATE - PostgreSQL SQL.

Answer 2

TRUNCATE , DML.

Answer 3

Oracle

DML. , , (), UNDO. . , . , , , .

- DDL , , . . , . , ( MINEXTENTS -, 1, , ). , , , , . : truncate - DDL, , , . ( , -no "WHERE" , , ).

, truncate , , , . , . Truncate DDL, COMMIT, , COMMIT, .

, TRUNCATE , DROP STORAGE .

Oracle Database SQL Reference 11.1, 10.2, 10.1 9.2 , "DROP STORAGE" TRUNCATE. :

"DROP STORAGE: specify DROP STORAGE to free all space from deleted rows from the table or cluster, except for the space allocated by the MINEXTENTS parameter of the table or cluster. This space can be used by other objects in the table space later. Oracle also sets the NEXT storage parameter to the size last degree removed from the segment during truncation. This is the default value. "