I created a table using a transaction group, but would like to delete it. How can I do this? I tried running 'system.db.runUpdateQuery("DROP TABLE tablename")' from the script console, but this didn't work. Do I need to use a different command to do this?
You can run queries in the "database browser" tool. Just make sure the comm is set to "read/write"
note: If something doesn't work, it's usually a good idea to explain what exactly happens. Errors you get, etc.
It's VERY hard to help if we don't know what's wrong.
2 Likes
In addition to this, using a tool like DBeaver as a GUI for the database makes a lot of these tasks easier.