You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hi there.
Whenever I create a view, dbeaver prefix all tables with database name like: SELECT * FROM users;
becomes SELECT * FROM mydb.users;
I already have SQL Editor/Code Completion option Use long object names... not selected.
Selecting SQL Editor/Code Completion option Use short object names... does not help.
Is there how to solve this, please?
Also, it expands the view code replacing * by each table column, for instance: SELECT mydb.users.id AS id, mydb.users.nome AS nome, (etc.) FROM mydb.users;
So, if I add a new column to a table, I have to recreate or add the new field to the view.
How to keep the query as typed, without any completion, please?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hi there.
Whenever I create a view, dbeaver prefix all tables with database name like:
SELECT * FROM users;
becomes
SELECT * FROM mydb.users;
I already have SQL Editor/Code Completion option Use long object names... not selected.
Selecting SQL Editor/Code Completion option Use short object names... does not help.
Is there how to solve this, please?
Also, it expands the view code replacing * by each table column, for instance:
SELECT mydb.users.id AS id, mydb.users.nome AS nome, (etc.) FROM mydb.users;
So, if I add a new column to a table, I have to recreate or add the new field to the view.
How to keep the query as typed, without any completion, please?
Beta Was this translation helpful? Give feedback.
All reactions