REMOVE vs TRUNCATE
REMOVE was mentioned in the viedo with no further explanation. Somehow, I tried to search this statement meaning online and found nothing. Could you please explain REMOVE? Whats the difference in function between the two?
Hi Angela!
Thanks for reaching out.
The DELETE command is used to delete particular records from a table. The TRUNCATE command is used to delete the complete data from the table.
Hope this helps.
Best,
Tsvetelin
Hi, thank you for your response. The instructor mentioned REMOVE when introducing DDL, and I think DELETE falls into the category of DML? Can anyone explain whats the REMOVE statement he meant in the viedo? I'm very confused.
Hi Angela and Tsvetelin!
I hope you don't mind if I join the conversation.
@Angela: There is no statement called REMOVE. Perhaps we meant that DELETE or TRUNCATE remove data from your database.
Hope this helps.
Kind regards,
Martin