Which statement is used to delete records from a table?

Which statement is used to delete records from a table?

• A. DELETE FROM table WHERE condition
• B. DROP TABLE table
• C. DELETE * FROM table WHERE condition
• D. REMOVE FROM table

Answer: (C)

Deleting rows from a table is done with the DELETE statement. You specify the table and a condition that selects which records to remove. The proper syntax is DELETE FROM table_name WHERE condition. The WHERE clause filters which rows are deleted; omitting it would remove all rows from the table, leaving an empty table. Note that you do not use an asterisk with DELETE—the asterisk is used with SELECT to indicate all columns, not with DELETE. Some dialects will reject forms like DELETE * FROM. The other options either drop the entire table or use non-existent keywords. So, the statement that deletes records is DELETE FROM table_name WHERE condition.

Deleting rows from a table is done with the DELETE statement. You specify the table and a condition that selects which records to remove. The proper syntax is DELETE FROM table_name WHERE condition. The WHERE clause filters which rows are deleted; omitting it would remove all rows from the table, leaving an empty table. Note that you do not use an asterisk with DELETE—the asterisk is used with SELECT to indicate all columns, not with DELETE. Some dialects will reject forms like DELETE * FROM. The other options either drop the entire table or use non-existent keywords. So, the statement that deletes records is DELETE FROM table_name WHERE condition.