单选题

从订单表中删除客户号为“1001”的订单记录，正确的SQL语句是

Question

A. DROP FROM 订单 WHERE 客户号="1001"

B. DROP FROM 订单 FOR 客户号="1001"

C. DELETE FROM 订单 WHERE 客户号="1001"

D. DELETE FROM 订单 FOR 客户号="1001"