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. How do I delete all columns? Thank you in advance.

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.

Blog Tutorials Examples Features Pricing Forum Docs Start Building

Anvil Community Forum

Delete all columns in a database

Anvil Q&A

owen.campbell January 18, 2022, 7:54am 2

You can’t do that, but you could upvote this feature request for it: