Which of the following statements will you use to delete a table from a database?

Which of the following statements will you use to delete a table from a database?
A . DROP TABLE <table_name>
B . DELETE TABLE <table_name> FROM DATABASE
C . REMOVE TABLE <table_name>
D . DELETE TABLE <table_name>

Answer: A

Explanation:

You will use the DROP TABLE statement to delete a table from a database.

The syntax is as follows:

DROP TABLE <table_name>

Here, the DROP TABLE statement is used to drop the table and the <table_name> 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 options D, C, and B are incorrect. There are no such types of statements available.

Reference: ECDL/ICDL Exam Course Manual, Contents: "DROP TABLE statement"

Chapter: DATABASE, ADVANCED-LEVEL

Objective: Query Design