TRUNCATE

TRUNCATE

To remove all records from the table you can use TRUNCATE statement.

Syntax:

TRUNCATE tableid

This is equivalent to DELETE FROM tableid statement.

See also: DELETE