SQL

Question

Which command is used to remove the datas from the table but it retains the structure of the table .

Answer 1

Ahh, a few days ago, I saw a thread discussing this topic, but unfortunately, I can’t find it in the search bar now.

Yeah exactly that's TRUNCATE. TRUNCATE TABLE removes all the rows quickly, and it's usually faster because it doesn't log individual row deletions. It also resets identity columns, which DELETE doesn't do. Both commands leave the table structure intact, but TRUNCATE is more efficient for removing all data. (It cannot be used if you want to retain specific rows).

One more thing, Don’t confuse it with DELETE (removes specific rows) or DROP (deletes the entire table, structure included).

Answer 2

Bharathi
You mean remove all data from a table but table should be there, then you can use TRUNCATE command.
Just write, `TRUNCATE TABLE table_name;`

Answer 3

Thanks a lot for answering my questions !!!!