Truncating a Table

You truncate a table using the TRUNCATE statement. This removes all the rows from a table and resets the storage area for a table.

SQL> TRUNCATE TABLE new_employee;

Table truncated.

SQL>

1. Creating a Table
2. Getting Information on Tables
3. Information on Columns in Tables
4. Renaming a Table
5. Truncating a Table
6. Dropping a Table