Rails 3.2.6 & database views creation through migrations

I'm using rails 3.2.6 and I need to create a database VIEW. As usual I created a migration and I tried to achieve the goal using the execute method.

Unfortunately the migration generates a table, not a view. Why?

Many thanks in advance, Mauro

UPDATE:

I would like to have something as follows:

class CreateMyView < ActiveRecord::Migration
  def self.up
    execute <<-SQL
      CREATE VIEW my_view AS SELECT ...
    SQL
  end
  def self.down
    execute <<-SQL
      DROP VIEW my_view
    SQL
  end
end

Unfortunately this migration creates a table...

UPDATE: the previous code works! I was executing rake db:reset instead of rake db:migrate:reset (my mistake)