Live briefing

Everything about Truncate (SQL)

Database command for removing data

In SQL, the TRUNCATE TABLE statement is a data manipulation language (DML) operation that deletes all rows of a table without causing a triggered action. The result of this operation quickly removes all data from a table, typically bypassing a number of integrity enforcing mechanisms. It was officially introduced in the SQL:2008 standard, as the optional feature F200, "TRUNCATE TABLE statement". Wikipedia →

🧭 Start here: a 6-step reading path

Read the overview: Truncate (SQL)A 5-minute orientation
Go sideways: Database triggerA closely related topic
Go sideways: Data control languageA closely related topic

📖 Definitions

No dictionary entry for this exact phrase.

🗂️ The subject at a glance

🏆 Landmark papers (most cited)

No matching papers found.

📚 Books worth reading

Open Library didn't respond; try again in a moment.

🔗 Related topics

Database trigger A database trigger is procedural code that is automatically executed in response to specific events on a table or view in a database. Triggers are commonly…
Data control language A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (authorization)…
Data definition language In the context of SQL, data definition language (DDL) is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements…
Delete (SQL) In the database structured query language (SQL), the DELETE statement is used to remove one or more rows from a table. A subset may be defined for deletion…
Data query language Data query language (DQL) is a term used to describe the subset of SQL statements concerned with retrieving data from a database. It is commonly presented…
SQL syntax The syntax of the SQL programming language is defined and maintained by ISO/IEC SC 32 as part of ISO/IEC 9075. This standard is not freely available. Despite…
Data manipulation language A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database…
Data Mining Extensions Data Mining Extensions (DMX) is a query language for data mining models supported by Microsoft's SQL Server Analysis Services product. Like SQL, it supports…