DELETE TABLE:
This SQL command is used to delete rows from a database table The syntax for the command is
DELETE [FROM] {table_name | view_name} [WHERE clause]where
table_name | view_name = [[database_name.]owner.]{table_name | view_name}
Specifies the table or view used in the DELETE statement. If the table or view exists in another database, use a fully qualified table_name or view_name (
WHERE clause = WHERE {search_conditions | CURRENT OF cursor_name}
Is used to perform a searched delete (using search_conditions) or a positioned delete (using CURRENT OF cursor_name). When no WHERE clause is given in the DELETE statement, all rows in the table are removed. The table itself, along with its indexes, constraints, and so on, remains in the database.
Remarks:
The DELETE statement removes rows one at a time and logs each deleted row as a transaction. If your table has a lot of records, you are better off using TRUNCATE TABLE instead.