Home » MCQs » SQL MCQs » SQL Basics (Set 2) MCQs

What does the DROP TABLE Statement do?

10. What does the DROP TABLE Statement do?

1. The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement.
2. A new table in SQL is created using this SQL statement.
3. Columns in the SQL database can be created, deleted, or modified with this SQL statement.
4. A new database will be created through this SQL statement.

Answer: A) The table, its structure, views, permissions, and triggers will also be deleted or removed with this SQL statement

Explanation:

The table, its structure, views, permissions, and triggers will also be deleted or removed with DROP TABLE SQL statement.