What is the difference between drop and truncate?

Answer 1

Drop=1. The smallest quantity of liquid heavy enough to fall in a spherical mass. See Table at measurement.
2. A small quantity of a substance.
3. drops Liquid medicine administered in drops.
4. A trace or hint: not a drop of pity.
5.
a. Something shaped or hanging like a drop.
b. A small globular piece of hard candy.
6. The act of falling; descent.
7. A swift decline or decrease, as in quality, quantity, or intensity.
8.
a. The vertical distance from a higher to a lower level.
b. The distance through which something falls or drops.
9. A sheer incline, such as the face of a cliff.
10.
a. A descent by parachute.
b. Personnel and equipment landed by means of parachute.
11. Something, such as a trapdoor on a gallows, that is arranged to fall or be lowered.
12. A drop curtain.
13. A slot through which something is deposited in a receptacle.
14. A central place or establishment where something, such as mail, is brought and subsequently distributed.
15.
a. A predetermined location for the deposit and subsequent removal of secret communications or illicit goods, such as drugs.
b. The act of depositing such communications or materials.
16. Electronics A connection made available for an input or output unit on a transmission line.

Truncate=1. To shorten by or as if by cutting off. See Synonyms at shorten.
2. To shorten (a number) by dropping one or more digits after the decimal point.
3. To replace (the edge of a crystal) with a plane face.
adj.
1. Appearing to terminate abruptly, as a leaf of a tulip tree or a coiled gastropod shell that lacks a spire.
2. Truncated.

Answer 2

Good Evening Mr. Kishore

Drop and Truncate are the sql statements that are run on database management system. Their objectives are as follows

Drop Sql Command

Drop Command drops a table from database.

Truncate Sql Command

Truncate Command is used to delete all the rows from a table.

Difference between Drop and Truncate Sql Commands

Drop command deletes both (structure of table and data of table) and table is not recoverable, where as truncate command only deletes the data from the table and structure of table is not affected.

Answer 3

Drop removes the table from the catalog. truncate empties data from within the table

Answer 4

drop - forget about it totally
truncate - cut it short or cut off (usually truncated to a set number of characters, such as 32, 52 or 64).

Answer 5

Kavitansh's Answer is Correct

. . .