How to remove tables?

[agruenberg]

First of all I want to say a big thank you all for your effort to establish such a great product!

I am struggling a little bit with the MySQL Connection: I renamed a table and since them the old one is still in the table list and cannot be removed. Any suggestion how to remove it? I need a way to do this without to fetch all tables again, because I would loose all formula columns.

Kind!

[poirazis]

Hey @agruenberg
Use the "Fetch Tables" button and it should refresh your table list and update to reflect any changes made in the underlying MySQL

[poirazis]

Unfortunately yes. But this is being worked on as I understand. To circumvent this as I use MySQL too, I added the needed formula columns as virtual in MySql.

[agruenberg]

Ah, I understand. Thank you very much!

[gmentzik]

Do you know if this loosing of formulas is fixed? In latest version fetch tables behavior changed! What do you mean by virtual columns?

[ConorWebb96]

Hey @gmentzik,

I've hopefully answered your question here; #11232.
This was only added recently, so this wasn't available on earlier versions of Budibase, I believe it was added from 2.8.2 onwards.

I hope this helps.

[melohagan]

As Conor mentioned in the linked answer, formula columns are no longer removed when you fetch tables.