Truncate Table in Teradata

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:
TruncateInTeradata

Leave a Reply