We had a table in our database having dot in the table name as below:
Table name – kpc.product_categories
On trying to delete kpc.product_categories using below command:
drop table kpc.product_categories
It used to give error that no such table exists.
Dot(.) is the reserved symbol in mysql so we have to avoid (.) as much as possible. But if unfortunately, we had such a table name use below sql command to drop it:
Sql Queries:
- SET sql_mode=’ANSI_QUOTES’;
- USE DATABASE “database_name” ;
- DROP TABLE “kpc.product_categories” ;
Or
DROP TABLE kpc.product_categories
Webner Solutions is a Software Development company focused on developing Insurance Agency Management Systems, Learning Management Systems and Salesforce apps. Contact us at dev@webners.com for your Insurance, eLearning and Salesforce applications.