Last answered:

08 Mar 2023

Posted on:

07 Mar 2023

0

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)
Instructor
Posted on:

08 Mar 2023

0

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

Posted on:

08 Mar 2023

1

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. 

Submit an answer