You are using a database named HumanResource. You have to delete some tables from the database using SQL statements. Which of the following statements will you use to accomplish the task?
DROP TABLE <table_name>
Correct:
DROP TABLE <table_name>
Explanation:
Answer option C is correct.
In order to accomplish the task, you will use the following statement:
DROP TABLE <table_name>
Here, the DROP TABLE statement is used to drop the table, and
the specifies the name of the table to be deleted.
The DROP TABLE statement removes the table from the database. It can only be recovered if the backup of the database is present.
Answer option D is incorrect. The following statement will generate an error:
DROP TABLE <table_name> FROM DATABASE
Answer options A and B are incorrect. There is no such statement as DELETE TABLE.