Delete table

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.

ChronoForms v8 is now WordPress ready, ChronoMails is out

The JED needs volunteers!

VPS & Email Hosting 20% discount