search

Budibase / budibase

Low code platform for building business apps and workflows in minutes. Supports PostgreSQL, MySQL, MSSQL, MongoDB, Rest API, Docker, K8s, and more 🚀
https://budibase.com
Other
21.23k stars 1.43k forks source link

Is there any way to delete columns? (If not: feature request!) #13910

Closed danielrosehill closed 3 weeks ago

danielrosehill commented 3 weeks ago

Perhaps I'm missing something but I didn't find a way to delete columns in Budibase?

The user has the requisite permissions but can only hide a column.

If I delete the column myself, the table will throw an error and there doesn't seem to be a way to fetch the updated structure.

Is this the case?

Now and again, I would like to delete columns that I've created using the wrong data type (or just don't need).

linear[bot] commented 3 weeks ago

BUDI-8341 Is there any way to delete columns? (If not: feature request!)

mike12345567 commented 3 weeks ago

Hi @danielrosehill - I'm assuming you are using a SQL database of some sort - if they are imported usually Budibase doesn't directly let you delete them. You can check by clicking "edit column" in the column menu as part of the data section, there should be a "Delete" button. image

If you are using a SQL DB you can re-fetch your table definitions if you change them externally you should re-fetch your tables to update their definitions - this can be done by clicking into the datasource and clicking the "fetch tables" button. image