Query Builder - Remove Database Name?

nowpc2 · Post by **nowpc2** » Thu 06 Jan 2011 02:47

I am using dbForge Studio (pro) v4.50 is there a way that I can stop the query builder from including the dtabase name in generated SQL?

For example, I would like the below code to only have "from table":

SELECT
table.*
FROM
databasename.table

Thanks in advance!

Alexz · Post by **Alexz** » Thu 06 Jan 2011 12:26

If you set your database as a current database for this document, statements will be generated without database name.
You can set current database for a document using the database combobox on the SQL toolbar.