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;
Code snippet
DELETE MYTDDB.MYTABLE ALL;