2 replies to this topic

[Patrick]

Can anyone tell me the difference between the delete and drop command in sql or oracle..as both commands are used to delete the objects then what features make them different from each other?Does anyone have any idea about this if yes then please help me..
Thanks a lot

[v0id]

DELETE is used for deleting rows in a table, while DROP is used for indexes, tables or databases. The syntax of the DROP-command differs much more from database to database, than with the DELETE-command.

[Patrick]

Delete command is used mainly to delete data from the rows and the drop command is used to completely drop the structure of the table and thus help in creating free memory space. If anyone can clear it more than please do reply