auto refresh maybe

DROP TABLE if EXISTS t;

CREATE TABLE t as select a,b,c from ......

Now if one looks at already opened t table data tab, sees only one column (was originally one column only), different data doh. All works normal, data refresh .... one column only

maybe after create table auto refresh current data tab table would be in place.

It works that way if you select drop table from drop down menu I might add. It refreshes.