I’m trying to delete all data in a data table, including columns and rows.
I have found the formula to delete all rows (app_tables.data.delete_all_rows()) and it works correctly. But I am trying to delete also all columns and it doesn’t work.
There are ways that Python can operate a browser, to automate manual steps (e.g., in the IDE), but I haven’t tried it. Seems like it would be complex, ugly, and fragile.
With a high-level subscription plan, you can get SQL access to the underlying database.
I do have a dedicated plan with SQL access, but I’m not going to modify any schema that was automatically created with the Anvil UI. I don’t want to risk to delete a column from one view and then the whole table stops working because I did the wrong thing with other support tables that keep track of whatever needs to be track kept.