In my database I login with a user that has no tables. The tables are in the dbo schema. When I run rake db:schema:dump the schema.rb gets create but no column definitions.

I tried putting ActiveRecord::Base.table_name_prefix = 'dbo.' in my Rakefile but I still get the same results. I hacked the file SchemaStatements#column_definitions by hardcoding

AND columns.TABLE_SCHEMA = 'dbo' ORDER BY columns.ordinal_position

this fixed the issue.

Is there something I am missing to configure the adapter to use schema dbo to use in the rake tasks?