Truncate table

sql

TRUNCATE TABLE staging_events;

Explanation

TRUNCATE is often faster than DELETE for clearing a table.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing CREATE, ALTER, and DROP

Define a new table with columns and constraints.

Open In sheetsqlsame section

Modify an existing table by adding a new column.

Open In sheetsqlsame section

Remove a table definition and its data.

Open In sheetsqlsame section

Attach a foreign key or check constraint after table creation.

Open In sheetsqlsame section

Add an index to improve lookup performance.

Open In sheetsql1 tag match

Mark a column as the main row identifier.