Delete table

Delete a database table without phpMyAdmin.

Overview

The user needed to delete a table but lacked access to phpMyAdmin and could not install new Joomla extensions.
Use a CF PHP action to execute a DROP TABLE query, ensuring you have proper backups and permissions first.

Answered
do doromi 27 Jul, 2018
Hi,
​
how can I delete a table either in CCv6 or in CFv6? I just found the way to delete records in my tables...
​
Unfortunately I don't have access to PhpMyAdmin, so I have to do it via Chrono products...
​
Thanks,
​
doromi
he healyhatman 27 Jul, 2018
Answer
Get PHPMyJoomla and google how to use MySQL to DROP table. This is really not a Chronoforms issue or question.
Gr GreyHead 28 Jul, 2018
Hi Doromi,
​
There are also Joomla extensions like AceSQL that will let you run MySQL commands from the Joomla admin - but take great care when deleting tables. Best to make a backup first just in case. something goes wrong.
​
Bob
do doromi 30 Jul, 2018
Hi healyhatman,
​
thanks for that answer. I can assure you that I would not have asked if I had known that.
​
Hi Bob,
​
thanks for your reply, too. Unfortunately I only am allowed to use the installed extensions on the current platform, but not to install additional ones.
So I simply will leave the table I wanted to delete and will create one with a new name.
​
Doris
he healyhatman 30 Jul, 2018
If you're not trusted to install additional components I can't see them being happy that you've messed around with the database.
​
But if you absolutely must, you could use a PHP action and drop the table that way.
​
​
mysql_query('DROP TABLE IF EXISTS `dbName`.`tableName`');
This topic is locked and no more replies can be posted.