A

Admin • 833.24K Points
Coach

Q. If you are asked to delete the entire data of a table without disturbing the table definition then in such case which statement you will use?

  • (A) DELETE
  • (B) TRUNCATE
  • (C) DROP
  • (D) CLEAR
  • Correct Answer - Option(B)
  • Views: 32
  • Filed under category MySQL
  • Hashtags:

Explanation by: Admin

To only remove the data of the table without disturbing the definition of the table we use the TRUNCATE statement, this statement helps us to delete all the data of a table.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.