Truncate a table
Truncating a table removes all data from the specified table immediately and irreversibly. It also removes all data from any materialized views derived from that table.
Use TRUNCATE TABLE
to truncate a table:
TRUNCATE TABLE <table_name>;