18.8k views
4 votes
The DROP command can be used to remove rows from an existing table.
a) True
b) False

User C Hogg
by
8.0k points

1 Answer

2 votes

Final answer:

The statement is false. The DROP command is used to remove entire database objects like tables, not individual rows. The DELETE command should be used to remove rows from a table.

Step-by-step explanation:

The statement that the DROP command can be used to remove rows from an existing table is false. The correct SQL command for removing rows from a table is DELETE, which allows you to specify conditions for which rows should be removed. In contrast, the DROP command is used to entirely remove a database object such as a table, index, or view. When you use DROP, the entire table structure along with its data is permanently deleted.

User Joshua Smith
by
7.6k points