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;