Teradata DELETE TABLE statement removes all the records from a Teradata table. The DELETE TABLE statement will delete only records, the table structure will remain the same.
Teradata DELETE TABLE Syntax
The syntax for deleting all records:
DELETE FROM database_name.tbl_name;
Here,
- database_name – The name of the owner database for the table.
- tbl_name – The name of the table from where you want to delete all the records.
The syntax for deleting selected records:
DELETE FROM database_name.tbl_name where condition;
Here,
- where condition – The condition for deleting specific row(s).
Teradata DELETE TABLE example
The following statement deletes all the records from the student database in the Teradatapoint database.
DELETE FROM Teradatapoint.student;
The below example delete only the specific employee from the employee table.
DELETE FROM Teradatapoint.employee where empid = 123;