SIGN UP MEMBER LOGIN:
   
ARTICLE
Reader Level:

TRUNCATE TABLE Command
 

 The TRUNCATE TABLE Command is used to remove/delete all the rows from a table permanently. The TRUNCATE TABLE Command can be faster than deleting all rows from table by using DELETE Statement.
 Rows deleted by the DELETE Command can be undo before changes to be committed But Using TRUNCATE TABLE Command don't allow undo changes (i.e. deleted rows can not get back).
 The TRUNCATE TABLE Command is good to use instead of dropping a table and recreate it because recreation of table requires you to re-create the indexes, integrity constraints, and triggers on the table and re-specify its storage parameters. Truncating the table only delete all rows.
 
 Syntax:
 
TRUNCATE TABLE table_name;
 
 Example:
 
The following example illustrates the TRUNCATE TABLE Command in Oracle SQL Plus:

TRUNCATE1.gif

Login to add your contents and source code to this article
This Feature is Sponsored By
post comment
COMMENT USING
TRENDING UP