1  TRUNCATE_TABLE
   Deletes the data in a table while still maintaining the metadata
   definitions of the table. Advantages include fast deletion of
   data in uniform areas, and no change to dependency data.
 

2  Environment
   You can use the TRUNCATE TABLE statement:

   o  In interactive SQL

   o  Embedded in host language programs to be precompiled

   o  As part of a procedure in an SQL module

   o  In dynamic SQL as a statement to be dynamically executed
 

2  Format

 TRUNCATE TABLE ---> <table-name> ---->
 

 

2  Arguments
 

3  table-name

   Specifies the name of the table you want to truncate.
 

2  Examples
   Example 1: Deleting data from a table while still maintaining the
   metadata definitions

   The following example shows how to delete the data from the
   SALARY_HISTORY table and still maintain the metadata definitions:

   SQL> TRUNCATE TABLE salary_history;
   SQL> --
   SQL> -- The table still exists, but the rows are deleted.
   SQL> --
   SQL> SELECT * FROM salary_history;
   0 rows selected
   SQL> SHOW TABLE (COLUMN) salary_history;
   Information for table SALARY_HISTORY

   Columns for table SALARY_HISTORY:
   Column Name                     Data Type        Domain
   -----------                     ---------        ------
   EMPLOYEE_ID                     CHAR(5)          ID_DOM
    Foreign Key constraint SALARY_HISTORY_FOREIGN1
   SALARY_AMOUNT                   INTEGER(2)       SALARY_DOM
   SALARY_START                    DATE VMS         DATE_DOM
   SALARY_END                      DATE VMS         DATE_DOM