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

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?

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
Not enough information to address the issue.
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). 

Customer support portal powered by UserEcho