EN
MySQL - drop table if exists
1
answers
4
points
I have a question how do I drop table if exists in MySQL?
I know it is possible in other databases.
Also I know I can remove this table with sql:
DROP TABLE `users_table`;
But it doesn't protect me from error if this table was already removed
or it never existed.
1 answer
2
points
Quickest way to do which will solve your problem:
DROP TABLE IF EXISTS `users_table`;
Explanation:
users_table
- database table name you want to remove
if exists
- will ensure you won't get any error if the table was never created
From MySQL documentation:
DROP TABLE IF EXISTS `table_name`;
0 comments
Add comment