Truncate (SQL)

id: truncate-sql-282-3892854
title: Truncate (SQL)
text: 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". TRUNCATE TABLE removes all rows from a table, but the table structure and its columns, constraints, i
brand slug: wiki
category slug: encyclopedia
description:
original url: https://en.wikipedia.org/wiki/Truncate_(SQL)
date created:
date modified: 2023-11-24T19:18:35Z
main entity: {"identifier":"Q2664576","url":"https://www.wikidata.org/entity/Q2664576"}
image:
fields total: 13
integrity: 13

Related Entries

Explore Next Part