Raymond Raymond

Truncate table in Teradata

event 2020-04-22 visibility 2,512 comment 0 insights toc
more_vert
insights Stats
toc Table of contents

In SQL Server, we can use TRUNCATE statement to clear all the records in a table and it usually performs better compared with DELETE statements as no transaction log for each individual row deletion.

The syntax looks like the following:

TRUNCATE TABLE { database_name.schema_name.table_name | schema_name.table_name | table_name }  
[;]  

Equivalent in Teradata

Unfortunately Teradata doesn't provide TRUNCATE TABLE statement. The similar statement is:

 DELETE TABLENAME ALL;
warning In previous Teradata version, there is performance differences between DELETE and DELETE ALL; however they are not equivalents and there is no performance differences according to Andrew Livingston from Teradata!

Code snippet

DELETE MYTDDB.MYTABLE ALL;


More from Kontext
comment Comments
No comments yet.

Please log in or register to comment.

account_circle Log in person_add Register

Log in with external accounts