Find the word definition

Crossword clues for truncate

Longman Dictionary of Contemporary English
▪ But in the truncated remnant that had been Maryland, the federal government just grew and grew.
▪ Have fun now, because you may have to settle for a truncated product next year.
▪ Lulled by a canned anthem, people rotate, debate, checkmate, gyrate and truncate.
▪ Maybe partially because of all the big-name actors, some in rather small roles, Cop Land seems truncated.
▪ The squares of the data values require more than six decimal figures and must therefore be truncated by the computer.
▪ We are emphatically not introducing an appeal system in order to truncate or bypass it.
▪ You can choose which field is used to make up the file name truncating it to a specified length.
The Collaborative International Dictionary

Truncate \Trun"cate\, v. t. [imp. & p. p. Truncated; p. pr. & vb. n. Truncating.] [L. truncatus, p. p. of truncare to cut off, mutilate, fr. truncus maimed, mutilated, cut short. See Trunk.] To cut off; to lop; to maim.


Truncate \Trun"cate\, a. [L. truncatus, p. p. ] Appearing as if cut off at the tip; as, a truncate leaf or feather.

Douglas Harper's Etymology Dictionary

late 15c., from Latin truncatus "cut off," past participle of truncare "to maim, mutilate, cut off," from truncus "mutilated, cut off, deprived of branches or limbs" (see trunk). Related: Truncated; truncating.

  1. 1 truncated 2 (context botany anatomy English) Having an abrupt termination. v

  2. 1 To shorten something as if by cutting off part of it. 2 (context mathematics English) To shorten a decimal number by removing trailing (or leading) digits; to chop. 3 (context geometry English) To replace a corner by a plane (or to make a similar change to a crystal).


adj. terminating abruptly by having or as if having an end or point cut off; "a truncate leaf"; "truncated volcanic mountains"; "a truncated pyramid" [syn: truncated]

  1. v. replace a corner by a plane

  2. approximate by ignoring all terms beyond a chosen one; "truncate a series"

  3. make shorter as if by cutting off; "truncate a word"; "Erosion has truncated the ridges of the mountains" [syn: cut short]

Truncate (SQL)

In SQL, the TRUNCATE TABLE statement is a Data Definition Language (DDL) operation that marks the extents of a table for deallocation (empty for reuse). 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 (though not physically) equivalent to the [[Delete (SQL)|DELETE]] FROM mytable statement (without a [[Where (SQL)|WHERE]] clause). The following characteristics distinguish TRUNCATE TABLE from DELETE:

  • In the Oracle Database, TRUNCATE is implicitly preceded and followed by a commit operation. (This may also be the case in MySQL, when using a transactional storage engine.)
  • 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.
  • You cannot specify a WHERE clause in a TRUNCATE TABLE statement—it is all or nothing.
  • TRUNCATE TABLE cannot be used when a foreign key references the table to be truncated, since TRUNCATE TABLE statements do not fire triggers. This could result in inconsistent data because ON DELETE/ON UPDATE triggers would not fire.
  • In some database systems, TRUNCATE TABLE resets the count of an Identity column back to the identity's seed.
  • In Microsoft SQL Server 2000 and beyond in full recovery mode, every change to the database is logged, so TRUNCATE TABLE statements can be used for tables involved in log shipping.

Usage examples of "truncate".

The buttresses are also ornamented with blind arches, and appear never to have been finished, as they are truncated in an unusual way where one would expect pinnacles.

It has the power of waving its spikelets, and of the thousand of truncated tentacles which cover the spikelets each seems to possess independent action.

He charged at the Californio, driving the man back with one combination of blows after another, many truncated, the fighting forms mixed about, the moves impossible to predict, even for him.

In the centre there is a group of elongated, cylindrical cells of unequal lengths, bluntly pointed at their upper ends, truncated or rounded at their lower ends, closely pressed together, and remarkable from being surrounded by a spiral line, which can be separated as a distinct fibre.

The greetings were in the truncated, collapsed Esperanto dialect of Vivolando.

To my left hangs a samurai sword, its truncated blade gleaming with threatening purpose.

About thirty meters from the foot of the purple slope, a human figure was standing, almost concealed, behind a pyramidal landform truncated at about shoulder height.

Waterspouts, twenty feet in diameter at their turbulent bases, streaked up whitely into the twilight, high above the truncated masts, hung there momentarily, then collapsed in drenching cascades on the bridge and boat-deck aft, soaking, saturating, every gunner on the pom-pom and in the open Oerlikon cockpits.

And the Seven Spheres of Borsippa were represented by the Seven Stories, each of a different color, of the tower or truncated pyramid of Bel at Babylon.

It was explored thus to the very summit of the truncated cone terminating the first row of rocks, then to the upper ridge of the enormous hat, at the bottom of which opened the crater.

Anderson, by the greater forward projection of the supraorbital ridges, and by its much deeper face, and the occipital region more abruptly truncated than in the other species.

Conn returned to the teleview screen in time to see the truncated cone of the extinct volcano rise on the horizon, dwarfing everything around it.

Once again she bared her ten truncated fingernails and once again they tried to seize my drum.

The presence of great truncated mounds, kindred to the pyramids of Central America, Mexico, Egypt, and India.

The seatback and the faintly vibrating, quietly humming, dimly glowing truncated cone of the engine-faring was between him and Elizabeth, a far more dangerous body.