Last answered:

22 May 2024

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? 

3 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. 

Instructor
Posted on:

22 May 2024

0

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

Submit an answer