Bright Tutorials Bright Tutorials
CBSE Class 12 Computer Science Question 8 of 43

Practice Paper — Question 8

Back to all questions
8
Question

Question 8

Mr. William wants to remove all the rows from table INVENTORY to release the storage space but he does not want to remove the structure of the table. What MySQL statement should he use?

Answer 
DELETE FROM INVENTORY;

This statement will delete all rows from the INVENTORY table, freeing up storage space, but it will not remove the structure or schema of the table.