152k views
4 votes
Which SQL statement can delete tables?
a. DROP
b. VOID
c. DELETE
d. SELECT

User Vlin
by
8.0k points

1 Answer

3 votes

Final answer:

The SQL statement used to delete tables is the DROP statement. It permanently removes a table and all associated data and indexes from the database, unlike the DELETE statement which only removes records, the correct option is A).

Step-by-step explanation:

The SQL statement that can delete tables from a database is a. DROP. The DROP statement is used to remove an entire table definition, its data, and its associated indexes from the database.

When you execute a DROP TABLE command, the specified table is permanently removed. The other options, such as DELETE, VOID, and SELECT, serve different purposes.

The DELETE statement is used to remove records from a table, SELECT is used to retrieve data from the database, and VOID is not a valid SQL statement.

User Andruso
by
7.3k points