SQL Query without Database Prefix

Avatar
Tim W (RustForge)
  • updated
  • Completed
Is there any option to remove the Database-Prefix from the query?

For example setting a Default-Database to for the query?
Replies 4
Avatar
0
Anonymous
To what database server you are connecting? Default database can be set in the Connection Properties dialog for some of the database servers (MySQL). 
Avatar
0
Anonymous
Not enough information to address the issue.
Avatar
0
Christian May

Hi there, 

Just came across the same question as Tim ..

Can you get rid of the databeprefix in the sql string

that is : SELECT field1, field2 FROM table1 WHERE ..

instead of : SELECT database1.field1, database1.field2 FROM database1.table1 WHERE ... ??

Thanks for the help

Avatar
0
Anonymous

Hello, Christian.

Default database can be set in the Connection Properties dialog for some of the database servers (SQL Server, MySQL). What are your database server and connection type?