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?
2 answers ( 0 marked as helpful)
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.