Coming from SQL Server & Oracle, I wanted a quick way in Teradata to truncate all the records from a table. The issue is the word TRUNCATE is not a reserved word in Teradata. Below is one of a couple ways to remove all the records in a table:
delete from databasename.tablename;
In my example below, I wanted to remove all the records in the Sales2018 table in the Retail database:
Leave a Comment