Description: Table created with SELECT INTO statement is not visible at table overview. After the SELECT ... INTO command the created table can be queried with SELECT command. Refresh the screen does not work. You have to safe the .ODB file and close the file and reopen the .ODB file again to see that the table in the table overview screen. Steps to Reproduce: 1. Run the SELECT... INTO... via Extra > SQL... (Execute SQL Statement) 2. Run SELECT * FROM [newtable] 3. Look at the Table overview 4. Use F5 to refresh screen 5. Safe & exit .ODB 6. Open .ODB file (new table is visible) Actual Results: Table does not show up in table list. Expected Results: Table does not show up in table list. Reproducible: Always User Profile Reset: Yes Additional Info: The table should be visible after creation User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:58.0) Gecko/20100101 Firefox/58.0
If you create a new table or do something else in Tools > SQL, which will changes the content of the database, please got to View > Refresh Tables This is the only way to get the new information from the database. If it works please set this bug to Resolved and Worksforme.
In the meanwhile, setting to NEEDINFO, pending user feedback
If you create a new table or do something else in Tools > SQL, which will changes the content of the database, please got to View > Refresh Tables