Interviews - C# Corner

Sapna Malik
What is the difference between Delete, Truncate and Drop in Oracle?
By Sapna Malik in SQL Server on Mar 18 2011
  • Sapna Malik
    Mar, 2011 18

    <font size="2"><font face="Verdana" size="2"><b>Delete:</b> The delete command means delete the value of the table. We can delete one or more rows of the table.<br><br></font></font><font size="2"><font face="Verdana" size="2"><b>Truncate: </b>The truncate command means delete all rows of the table. The truncate is a data definition language (DDL) command and this command delete the all rows of the table.</font></font><br><br><font size="2"><font face="Verdana" size="2"><b>Drop:</b> The drop command means delete the table from the database. The drop command is a data definition language (DDL) command and this is a table oriented command. </font></font><a href="http://www.dbtalks.com/UploadFile/vishu/1032/">More....</a><br>

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS