Skip to main content
to truncate

to truncate

1 7.0
To remove all rows from a table to make it empty
  • verb
  • /ˈtrʌŋkeɪt/
  • Specialized
translation icon : truncar
  • On Friday, Nov. 2, "Undercover Boss" will launch its fourth season in the Friday 8 p.m. slot, returning to the hour it took over (with variable success) last spring after "A Gifted Man" ended its truncated run.

Examples

  • You can use the TRUNCATE command to quickly truncate all rows in the database table.

  • Your feed seems to be broken on Planet Python: * the post content is truncated, so we cannot read it * the link to the individual post doesn't point to the post (it points to 'planet.python.org' instead), so we cannot read the full version * the link to the blog works, at least, so we can read the full post if we really, really want to.

    Blog text (6)
  • Beyond that, the search engines will generally truncate anything more than that.

    Blog text (10)
  • Of course, access by people involved in court matters can legally truncate some of our demands.

    Academic text (2005)
  • And we're going to diddle around a little bit with a question of how to truncate these series.

  • We have the sentence, we truncate, we predict and we keep going till we learn these probabilities.

  • However, we decided to display only three random book cover images at the top of each screen and to truncate the book descriptions at 300 characters to prevent the title lists from becoming too lengthy.

    Academic text (2012)
  • So basically I truncated the lookup tables just using the last value from each waveform.

  • After running the script, it will truncate the dataset to improve processing speed.

  • To reset the table for new data, we need to truncate its contents completely.

Synonyms

to delete
vsto truncate
287 2.0

To remove information like text or files so it cannot be seen

targets removal of every row in a table to quickly reset contents
to clear the table
vsto truncate
  • Specialized
1 4.2

Remove all rows from a database table to make it empty

is a database command that quickly empties a table to reset contents

Antonyms

20 3.9

A piece placed inside something to give information or protect it

to populate
  • Specialized
15 4.9

Fill a database or form with data by adding records

How Empty

to clear the table
  • Specialized
1 4.2
to truncate
  • Specialized
1 7.0

Surface Forms

truncate infinitive
truncated past
truncated past participle
truncating present participle
truncates third person singular

Morphology

truncate = trunc + ate

The database command sense is a technical/metaphorical extension of 'cutting off' or removing content; the morphological structure is the same but the specialized usage makes it less immediately inferable for general learners.

Etymology

The word truncate in computing comes from the same Latin truncare and truncus 'trunk', with the idea of cutting something away. Imagine emptying a trunk or quickly chopping out the inside of a container. So to truncate a table is to 'remove' all its rows fast, like clearing it out.