Is there a way to set a default schema for queries?

  • updated
  • Completed
I can't find a way in the product. Would you consider adding this? It would be tremendously useful. I sometimes need to copy very long SQL scripts from an existing system in which a default schema is assumed. Right now I need to trawl through all the coding, prefixing every table and column reference to include the schema name. Would be so much easier if I could set a default schema name for a connection - even for all connections, cos I always use the same schema.
Currently the default schema is determined automatically according to the currenly logged user rights. For MySQL and MS SQL Server you can specify default database in Connection Properties. I suppose it might be helpful to let parse specific queries with different default schema settings.