Hi Lukas, In SQL Server, it seems it is not possible to specify the schema of the database because the schema is bound to the user. Thus, "Factory.use(Schema)" has no effect and all fields have the "[schema]." prefix.
Wouldn't it be possible for jOOQ to remove that prefix if the default schema of the connected user (as returned by "SELECT SCHEMA_NAME()") is the one defined by "Factory.use()"? Please correct me if my understanding of database, users and schemas in SQL Server is wrong. -Christopher
