Remove username from table names in SQL Worksheet

b7ca3201-4486-40c0-99e6-9b5d1364c134 Feb 10, 2020 5:48 PM

I'm needing to hide or remove the feature that adds the database username before the table name in SQL Worksheets. For example, when using Query Builder in v19.4.0.354 to link tables, it causes table names and columns to be prefixed with the connected database username. Example,

SELECT DBUSERNAME.TABLE.COLUMN FROM DBUSERNAME.TABLE;

Is there a preference to turn this off? I did not experience this setting in v4.0.3.16.

Thanks,

Seth

1. Re: Remove username from table names in SQL Worksheet

Peter de Vaal Feb 11, 2020 1:22 PM (in response to b7ca3201-4486-40c0-99e6-9b5d1364c134)

This is indeed behaviour that is not desirable when no option is available to switch it off.
I usually build SQL statements by dragging the table from the browser onto the worksheet, then the table name is not prefixed with the schema name.
Like Show 0 Likes(0)

Actions