When the correct SQL command is used to delete a table's structure,what happens to the data in the table?
A)If the deleted table was a parent table,the data is added to the appropriate rows of the child table.
B)If the deleted table was a child table,the data is added to the appropriate rows of the parent table.
C)The data in the table is also deleted.
D)Nothing because there was no data in the table since only an empty table can be deleted.
E)A and B

Question

Quizplus · Accepted Answer

When a table's structure is deleted, this means that the entire table is deleted including all the data in it. Therefore, option C is the best choice. Options A and B do not make sense because they suggest that the data is moved to another table instead of being deleted. Option D is incorrect because even if the table is empty, the table structure is still deleted. Option E is also incorrect because both options A and B cannot be true at the same time.

When the Correct SQL Command Is Used to Delete a Table's