Cyber Security Interview Questions and Answers › Cyber Security
DELETE vs TRUNCATE vs DROP in SQL?
All three remove data. DELETE removes rows. TRUNCATE empties the table. DROP deletes the table itself. One wrong command can wipe data; know which is which.
Read card text
What this card says
All three remove data. DELETE removes rows. TRUNCATE empties the table. DROP deletes the table itself. One wrong command can wipe data
know which is which.
Learn more in the lesson: 11.4 DELETE, TRUNCATE and DROP