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.

For deleting all the records
DELETE FROM tablename

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

DELETE FROM tbl_emp 

DELETE FROM tbl_emp WHERE emp_id=12345