To retain the structure of a table,while deleting all its data and releasing their storage space,execute the TRUNC command.

Name: To retain the structure of a table,while deleting all its data and releasing their storage space,execute the TRUNC command.
Brand: Quizplus
Rating: 4.7 (43 reviews)

Question

To retain the structure of a table,while deleting all its data and releasing their storage space,execute the TRUNC command.​

Quizplus · Accepted Answer

The TRUNCATE command is used to delete all data from a table while retaining its structure, but it does not release the storage space. To release storage space, the DROP command should be used.

To Retain the Structure of a Table,while Deleting All Its