Definitions for truncateˈtrʌŋ keɪt
This page provides all possible meanings and translations of the word truncate
terminating abruptly by having or as if having an end or point cut off
"a truncate leaf"; "truncated volcanic mountains"; "a truncated pyramid"
replace a corner by a plane
approximate by ignoring all terms beyond a chosen one
"truncate a series"
truncate, cut short(verb)
make shorter as if by cutting off
"truncate a word"; "Erosion has truncated the ridges of the mountains"
To shorten something as if by cutting off part of it.
To shorten a decimal number by removing trailing (or leading) digits; to chop.
To replace a corner by a plane (or to make a similar change to a crystal).
Having an abrupt termination.
Origin: From truncatus, perfect passive participle of trunco; see trunk as a verb.
to cut off; to lop; to maim
appearing as if cut off at the tip; as, a truncate leaf or feather
In SQL, the TRUNCATE TABLE statement is a Data Definition Language operation that marks the extents of a table for deallocation. 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. The TRUNCATE TABLE mytable statement is logically equivalent to the DELETE FROM mytable statement. The following characteristics distinguish TRUNCATE TABLE from DELETE: ⁕In the Oracle Database, TRUNCATE is implicitly preceded and followed by a commit operation. ⁕Typically, TRUNCATE TABLE quickly deletes all records in a table by deallocating the data pages used by the table. This reduces the resource overhead of logging the deletions, as well as the number of locks acquired. Records removed this way cannot be restored in a rollback operation. Two notable exceptions to this rule are the implementations found in PostgreSQL and Microsoft SQL Server, both of which allow TRUNCATE TABLE statements to be committed or rolled back transactionally.
Images & Illustrations of truncate
Translations for truncate
From our Multilingual Translation Dictionary
- подкосен, подкосявамBulgarian
- ακρωτηριασμένος, κολοβός, περικομμένος, περικόπτω, κονταίνωGreek
- truncado, truncarSpanish
- katkaista, typistää, lyhentääFinnish
- tronqué, tronquer, tronquéeFrench
- beneden, afkappen, afhakken, afronden, naarDutch
- усечённый, укороченный, усекатьRussian
Get even more translations for truncate »
Find a translation for the truncate definition in other languages:
Select another language: