Scribd
Upload
4 views1 page

SQL Commands: TRUNCATE, DELETE, DROP Explained

TRUNCATE is a command that quickly removes all rows from a table while keeping its structure intact. DELETE allows for the removal of specific rows based on conditions and is transactional. DROP completely removes a database object, including all its data, and is not transactional.

Uploaded by

nrktraders1100
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views1 page

SQL Commands: TRUNCATE, DELETE, DROP Explained

TRUNCATE is a command that quickly removes all rows from a table while keeping its structure intact. DELETE allows for the removal of specific rows based on conditions and is transactional. DROP completely removes a database object, including all its data, and is not transactional.

Uploaded by

nrktraders1100
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

TRUNCATE: is used to quickly remove all rows from a table without destroying the

table structure.
DELETE: is used to remove specific rows from a table based on a condition, and it's
transactional.
DROP: is used to completely remove a database object, such as a table or database,
along with all its data, and it's not transactional.
absent data

You might also like