Database - SQL for Database Construction - Discussion

SQL "delete from table name" deletes all the data of the table where as "drop tablename" deletes data as well as structure of the table.

Delete command does not delete the segment but truncate command delete the segment.

What is the difference between delete, truncate, drop?

First read the statement C carefully. You are right but the right answer is B.

Its true that DROP TABLE sql statement deletes table structure along with data but if integrity constraints exits in table such as in Table1, unique/primary key referenced as foreign key in some other table such as Table2 then Table1 cannot be dropped. As data of some column in Table1 are referenced or we can say used by some column in Table2, so if Table1 would be dropped, then how will Table2 retrieve data from Table1 when Table1 will be dropped.
Therefore, right answer is [C]

Delete Table deletes the table data.