DELETE records from a table in Teradata

You can delete the records from a table from DELETE or DEL keyword.
Only the records will be deleted and the table structure will remain the same.

Syntax:
For deleting all the records
DELETE FROM tablename


For deleting particular records, you can give a filter condition.
DELETE FROM tablename WHERE condition


Examples:
DELETE FROM tbl_emp 

DELETE FROM tbl_emp WHERE emp_id=12345