SQL DROP query request

Question

I used DROP ecommerce.users; but it shows error #1064. Kindly help.

Does this answer your question? [How can I fix MySQL error #1064?](https://stackoverflow.com/questions/23515347/how-can-i-fix-mysql-error-1064) — hppycoder, Mar 15 '21 at 15:31

score 0 · Accepted Answer · answered Mar 15 '21 at 15:37

I think you want to use:

DROP TABLE `ecommerce`.`users`;

Just DROP by itself is ambiguous. There are several different types of things you can drop in a MySQL database. Tables, indexes, triggers, views, procedures, or even a schema. You have to be specific. The word TABLE is necessary.

See https://dev.mysql.com/doc/refman/8.0/en/drop-table.html

SQL DROP query request

1 Answers1