A data analyst has a managed table table_name in database database_name. They would now like to remove the table from the database and all of the data files associated with the table. The rest of the tables in the database must continue to exist.
Which of the following commands can the analyst use to complete the task without producing an error?
To remove a specific managed table from a database and delete all associated data files while keeping the rest of the tables intact, the correct command is to use the DROP TABLE statement with the full identifier of the table. The correct syntax is DROP TABLE database_name.table_name;. This will ensure that only the specific table is removed and all its data files are deleted.
Provided answer is correct
Answer is : B