Definitions for truncateˈtrʌŋ keɪt
This page provides all possible meanings and translations of the word truncate
Random House Webster's College Dictionary
trun•cateˈtrʌŋ keɪt(v.; adj.)-cat•ed, -cat•ing
(v.t.)to shorten by or as if by cutting off a part; cut short.
Biol. square or broad at the end, as if cut off transversely. lacking the apex, as certain spiral shells.
Origin of truncate:
1480–90; < L truncātus, ptp. of truncāre to lop, der. of truncustrunk ; see -ate1
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.
Find a translation for the truncate definition in other languages:
Select another language: