Sapna Malik
What is the difference between Delete, Truncate and Drop in Oracle?
Posted by Sapna Malik in SQL Server on Mar 18, 2011
  • 0
  • 1
  • 3966
Do you know the answer for this question? Post it below.
Guest
Posted by Sapna Malik on Mar 18, 2011
  • 0

Delete: The delete command means delete
the value of the table. We can delete one or more rows of the table.

Truncate: 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.


Drop: 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.
More....


PRIVACY POLICY | TERMS & CONDITIONS | SITEMAP | CONTACT US | ABOUT US | REPORT ABUSE
2014© C# Corner. All contents are copyright of their authors.