# \[BUG\] Refreshing the database list in Database Query Browser wipes all queries **URL:** \ **Category:** Ignition\ **Created:** [July 29, 2022, 5:01am UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438 "2022-07-29T05:01:13Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\ **Post date:** [July 29, 2022, 5:01am UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/1 "2022-07-29T05:01:13Z")
v8.1.18 Very annoying. All query tabs are cleared when you press “refresh” to update the database list with added tables/schemas. Also annoying that adding a new query doesn’t also select it. There’ve been so many times I’ve replaced my query by adding a new tab and double clicking on a schema 😕 ---
**Author:** ![martinel3746](https://avatars.discourse-cdn.com/v4/letter/m/e0b2c6/32.png) [@martinel3746](https://forum.inductiveautomation.com/u/martinel3746)\ **Post date:** [July 29, 2022, 3:22pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/2 "2022-07-29T15:22:56Z")
Yes, please keep the queries when changing the selected schema. I’ve had to start over with a lot of queries when selecting a different schema. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [July 29, 2022, 4:43pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/3 "2022-07-29T16:43:41Z")
Hard agree here. I have a gateway that has both the dev and prod version of the application and is connected to the dev and prod database. It’s annoying when I am trying to compare a difference between dev/prod in the database query browser and switching the schema wipes it. I’ve learned to copy it before and now but still would just be better if it didn’t wipe it. ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [July 29, 2022, 4:50pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/4 "2022-07-29T16:50:10Z")
I’m actually shocked people use that for actual work. 😜 Use whatever tool is made for your database of choice. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [July 29, 2022, 4:54pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/5 "2022-07-29T16:54:17Z")
It’s a nice convenience as many times just running a few SELECT’s is all the debugging I need to see table column names, and it’s faster/easier than swapping between designer and your db workbench imo. But I do also have a handful of situations where I don’t have direct access to the database, and Ignition and literally my only view into the db as the credentials are kept by IT (and I don’t have the knowledge to look at Ignition’s internal db to get them lol) so it’s actually very helpful in those cases. ---
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [July 29, 2022, 4:55pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/6 "2022-07-29T16:55:41Z")
Yeah I can see the use cases, I was being a bit facetious. I also use it for quick checks but any serious stuff I just use the workbench. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [July 29, 2022, 5:07pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/7 "2022-07-29T17:07:27Z")
Since we are on the topic though - `DESCRIBE someTable` doesn’t execute in Database Query Designer but executes fine in system.db.runQuery. I use describe a good deal to understand a tables schema. I think it thinks its an update query? ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/0/90171980678b698501f43d3a6ff42152662083e6.png) But it works perfectly fine in scripting ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/d/b/db47f776a93eec3eb8828c7be015beeba72e513d.png) ---
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [July 29, 2022, 5:16pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/8 "2022-07-29T17:16:47Z")
Yes, the query browser has to infer from the text whether it should use update vs. select. There are many syntax variants among DB brands that it doesn’t understand. ---
**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Post date:** [July 29, 2022, 5:22pm UTC](https://forum.inductiveautomation.com/t/bug-refreshing-the-database-list-in-database-query-browser-wipes-all-queries/62438/9 "2022-07-29T17:22:30Z")
Ah ok. For some reason I thought maybe the JBDC you use for the db connection would be assisting with this and “know” that DESCRIBE is a select. Not a big deal since it still works in scripting.