What Is The Difference Between TRUNCATE And DELETE Commands
both the functions prform the same operation but the truncate operations cannot be rolled back
Delete is for Deleting the Data in the logical object here there might be some filtering criteria in the Delete selection.
Truncate will delete the Data and structure and Data also from the table so once the Structure is Delete if u are performing the Rollback is meaning less.
TRUNCATE is a DDL command whereas DELETE is a DML command. Hence DELETE operation can be rolled back, but TRUNCATE operation cannot be rolled back. WHERE clause can be used with DELETE and not with TRUNCATE.
2009-2016 downloadmela.com. All rights reserved.