1.

What is the main disadvantage of deleting data from an existing table using the DROP TABLE command?

Answer»

DROP TABLE command deletes complete data from the table along with removing the complete table structure too. In CASE our requirement entails just remove the data, then we would NEED to RECREATE the table to store data in it. In such CASES, it is advised to use the TRUNCATE command.



Discussion

No Comment Found